Summarized Report showing average duration in each status

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!

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.

I have a Status Change Log that captures the time and date of the change, but not something that shows exact start and end times for the status.

Is there a new type of log or table I should make?

The "logging changes" option is not report-able, or really usable at all.

You will want these to be child records for every time the status changes.

You can make the button end one status and start another, or you can use an action to edit / add. 

Either way you will need those records to see the actual duration's  for each status.

Thanks, and do you have any suggested resources/links for how to setup this child table?  I just began learning QuickBase 4 days ago, so the help is much appreciated!

Funny you should ask.  I'm in the process of writing an in depth blog post about this topic.  With the 'how to' as well.  I'll share it once i post it. 

Can't wait - will really help our project!

Alex, did you ever get what you needed.  I am in the same boat, have a table logging the status when it changes but don't know how to summarize the time spent in a particular status.