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!

Try using the "grouping" option to put your status options as the grouped columns.

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.

.. 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.

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?

Summarized Report showing average duration in each status

MCFNeil
Qrew Captain
8 years ago
Try using the "grouping" option to put your status options as the grouped columns.
- 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!
- 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.
- AlexJames
  Qrew Trainee
  8 years ago
  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?
QuickBaseCoachD
Qrew Captain
8 years ago
.. 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.
- AlexJames
  Qrew Trainee
  8 years ago
  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!
- QuickBaseCoachD
  Qrew Captain
  8 years ago
  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.

Forum Discussion

Summarized Report showing average duration in each status

Related Content

Show related records

Dashboard Format Question (summarizing)

Duration Fields with Pipelines

Form Rule "Show Report" displays No options

Create a formula duration over 5 years