Business Elpased Time List View for Incidents

Britton
Mega Contributor

Good day, I'm able to see the business elapsed time when I report on the SLA table, however when I report on the incident table I can only select 'business duration' for a column, however this doesn't appear to take into account pause conditions like 'business elapsed time' does. 

In the end I want a report in a list view that shows the 'business elapsed time' on incidents without any associated incident tasks.  Similar to the below but I can only get 'business duration' as shown below to appear which apparently doesn't take into consideration pause conditions on our SLA such as 'on hold' states.  Any help is appreciated!

 

find_real_file.png

Thanks!

5 REPLIES 5

Thanks, unfortunately its still populating zeros.  I checked the column/field name on the task sla table for business elapsed time, it was 'business_duration' I updated the script and still encounter all 0's.  Thanks!