We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Time in Status (Transactions Calculation w/ Custom Script) - Analytics Cookbook Recipe

Received Response
155
Views
8
Comments
edited Apr 29, 2020 5:12PM in Reporting & Analytics for B2C Service 8 comments

Content

 

 

Time in Status

 

 

 

 

Calculates time using custom script

 

 

 

 

Author: Bastiaan van der Kooij

Independent Oracle Service Cloud Consultant

 

 

 

 

Difficulty rating:   (Advanced)

 

 

 

 

Target persona: Anyone interested in Incident status transitions

 

 

 

 

Ingredients:

 

 

 

 

Columns 

 

 

 

 

1 Custom Script

 

 

 

 

Overall description/purpose: This report uses the status transactions from the transactions table to display all status changes from an incident, sorted by the date the status was changed. Using a custom script the time that the incident spent in that particular status is calculated and displayed back to the report user.

 

 

 

 

Use case being served: This type of granular status data is not stored in the inc_performance table. Using the transactions table alone there is no way of calculating the time spent in a particular status. To avoid using external solutions this report with custom script can be used.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!