Summarized Report showing average duration in each status

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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 case owners as rows.

Appreciate any and all assistance!
Photo of Alex James

Alex James

  • 122 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Try using the "grouping" option to put your status options as the grouped columns.
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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.
Photo of Alex James

Alex James

  • 122 Points 100 badge 2x thumb
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!
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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. 
Photo of Alex James

Alex James

  • 122 Points 100 badge 2x thumb
Can't wait - will really help our project!
Photo of Stephanie

Stephanie

  • 722 Points 500 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
.. just chiming into this thread here.  I have to do this for a client and it was "non trivial".

I had to make a child table  for the Status change records and each one had  start  and stop date time fields.  To change status, the user would click a button on ghe parent help ticket which would update the most recent status record to "stop it" with the date/time of now(), and then add a new child status record and "start it" it now().

Then the actual status for the main help ticket record was a reverse lookup from the most recent child record.

Then I could make summary fields on the help ticket for the total time spent in each stataus.
Photo of Alex James

Alex James

  • 122 Points 100 badge 2x thumb
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!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
There are Quick Base Solution Providers like Matthew and myself among other organization which do Quick Base training.

I guess that you can wait for Matthew to do his write up.  

You will need to learn about how to set up Relationships.

There is the Quick base university as a resource centre to watch the videos.  https://university.quickbase.com/

This forum is a great resource for any specific questions.