Ability to run Report on all jobs and how long they stayed in a certain status
For example: We want to know on average how long jobs are staying in QC Inspection status.
Right now, I can report on the jobs specifically in that status, but I want a way for even if they are not in the status currently.
Basically the length of time between status changes. (Which I know you can see when you go into a job's system activity - but I want to run a report on this).