Forum Discussion

AlexJames's avatar
AlexJames
Qrew Trainee
8 years ago

Summarized Report showing average duration in each status

I'm trying to create a summarized report that shows the average time all cases spend in each status.  Once I have that with the status as rows, I'd like a separate report with statuses as columns and ...
Ask about Quickbase functionality
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Try using the "grouping" option to put your status options as the grouped columns.
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Do you have those data points as individual records?  i.e. Do you have a record for every time the status changes, and the start and end times of those status changes?

typically people just have a drop-down with the options, but QB doesn't (by default) track how long it was in that status.