Report to show duration between each status change
I set up notifications to go to a GMail account for any changes to a "Status" field (multiple choice). I then made a new table title "Edit Log" and linked it to the GMail data. Within this table, I have columns "Subject" and "Date Created" ....Within the Subject column for my notifications, I've chosen to display the Record ID, Date, and Status (ie Billed, Invoiced, etc.)
Can I somehow create a report to show duration between each change on a each record? I'm trying to find any delays in our billing work flow.
Example:
Record 20
Status changed "Report Generation" to "Billed" on 3/12/17
Then changed from "Billed" to "Invoiced" on 3/24/17
Those are reflected in my QB table as:
Subject Date Created
20,3/12/17,Billed 3/12/17
20,3/24/17,Invoiced 3/24/17
In order to do what I need, I feel like I need additional fields for the Record, and Status, but not sure if it's possible to show duration once I get those fields to populate (Using functions "Right" and "Left"). I hope I'm making sense! Any input is appreciated.
Can I somehow create a report to show duration between each change on a each record? I'm trying to find any delays in our billing work flow.
Example:
Record 20
Status changed "Report Generation" to "Billed" on 3/12/17
Then changed from "Billed" to "Invoiced" on 3/24/17
Those are reflected in my QB table as:
Subject Date Created
20,3/12/17,Billed 3/12/17
20,3/24/17,Invoiced 3/24/17
In order to do what I need, I feel like I need additional fields for the Record, and Status, but not sure if it's possible to show duration once I get those fields to populate (Using functions "Right" and "Left"). I hope I'm making sense! Any input is appreciated.
