Forum Discussion
MCFNeil
8 years agoQrew Captain
Try using the "grouping" option to put your status options as the grouped columns.
- AlexJames8 years agoQrew TraineeDoing 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! - MCFNeil8 years agoQrew CaptainDo 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. - AlexJames8 years agoQrew TraineeI 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? - MCFNeil8 years agoQrew CaptainThe "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. - AlexJames8 years agoQrew TraineeThanks, 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!
- MCFNeil8 years agoQrew CaptainFunny 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.
- AlexJames8 years agoQrew TraineeCan't wait - will really help our project!
- StephanieHarris7 years agoQrew Assistant CaptainAlex, 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.