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.
AlexJames's avatar
AlexJames
Qrew Trainee
8 years ago
Doing that gives me the average age of all cases that currently have the column's status.  I'm looking for the average time cases have stayed in each status.

Put another way, instead of "the average age of all Alex's cases that currently have Ready for Review status" I'm looking for "the average time Alex's cases spend in Ready for Review".

Thanks for your help!