Calculating Review Time & On Time Percentage
How to calculate review time for a review cycle, average review time, and on time percentage
Required Fields - Child Object
Date/Time - Submitted Date Time
Date/Time - Review Started Date Time
Date/Time - Review Completed Date Time
Equation - Total Days
Equation - Days Under Review
Equation - Days Idle
Multiple Choice - Review On Time
Date Time Fields
These fields capture action timestamps when a record is created/submitted and when the reviewer either starts or finishes a review process. Make sure to set them up to capture time so we can accurately capture and calculate the review time. Be sure to not default date or time.
For these equations, Equation Type must be set to Numeric and we add 2 Decimal Places
Total Days
If the Review Completed Date is blank, we used the netWorkDays function to calculate the time difference between the Submitted Date and Current Date with the currentTime function. Otherwise, if Review Completed Date is not blank, we use the netWorkDays function to calculate the business days from Submitted Date to Review Completed Date.
netWorkDays function does not count Saturday or Sunday when determining time.
Days Under Review
If the Review Completed Date is blank, we used the netWorkDays function to calculate the time difference between the Review Started Date and Current Date with the currentTime function. Otherwise, if Review Completed Date is not blank, we use the netWorkDays function to calculate the business days from Review Started Date to Review Completed Date.
Days Idle
If the Review Started Date is blank, we used the netWorkDays function to calculate the time difference between the Submitted Date and Current Date with the currentTime function. Otherwise, if Review Started Date is not blank, we use the netWorkDays function to calculate the business days from Submitted Date to Review Started Date.
Review On Time
We setup this field as a Multiple Choice instead of a Yes/No in case there becomes a third option in the future. Right now we want to figure out if a review is on time or not on time. We setup two conditionals based on the Days Idle equation to determine if the review started less than 28 days after being submitted or if the review started after 28 days of being submitted.
The On Time field could also be setup to determine if the Days Under Review or the Total Days values exceed certain day thresholds.
Required Fields - Parent Object
Average - Average Days Under Review
Average - Average Days Idle
Average - Average Total Duration
Count - Number of On Time Reviews
Equation - Percentage of On Time Reviews
Number - Reviews On Time %
Average Fields
For these Average fields we set them up with 1 decimal place and some filters to make sure the value is not 0 or blank. We use these averages for reporting to give us a general sense of how long reviews are taking on average during different stages of the process.
Number of On Time Reviews
We simply just count the number of review records where the Review On Time value is On Time
Percentage of On Time Reviews
We take the count field Number of On Time Reviews and divide it by the count field Number of Reviews (the total). We make sure to set this to two Decimal Places to give us a more precise percentage.
Reviews On Time %
We set the Number Format to % and set it the the Percentage of On Time Reviews equation
The On Time % can be used for an entire case or per reviewer for example.
Last updated
