In this recipe, you'll learn how to report on handling time per update. You can use this information to report on individual agent performance, or to report on complex workflows where the same ticket is handled by multiple agents.
This recipe contains the following topics:
Related articles:
- Time Tracking app - Metrics you need to be measuring
- Explore recipe: Time Tracking app - Measuring ticket handling time
What you'll need
Skill level: Intermediate
Time required: 15 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (See Giving users access to Explore)
- Time Tracking app installed and configured (See Setting up the Time Tracking app)
Creating the standard calculated metric
To report on update handling time, you'll first need to create a standard calculated metric.
To create the standard calculated metric
- In Explore, click the Reports () icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Updates history, then click Start report. The report builder opens.
- Click the Calculations menu (), and select Standard calculated metric.
- In the Name field, enter a name for your calculated metric, such as Update handling time (min) (or (min)).
- In the Formula field, enter the formula below:
IF ([Changes - Field name] = "Total time spent (sec)")
If you want to measure update handling time in hours, use the following formula instead:
THEN
IF (([Changes - Previous value]=NULL OR [Changes - Previous value]="") AND [Changes - New value]!="")
THEN NUMBER([Changes - New value])/60
ELIF (REGEXP_MATCH([Changes - New value], "[0-9]+") AND REGEXP_MATCH([Changes - Previous value], "[0-9]+"))
THEN(NUMBER([Changes - New value])-NUMBER([Changes - Previous value]))/60
ENDIF
ENDIFIF ([Changes - Field name] = "Total time spent (sec)")
THEN
IF (([Changes - Previous value]=NULL OR [Changes - Previous value]="") AND [Changes - New value]!="")
THEN NUMBER([Changes - New value])/60/60
ELIF (REGEXP_MATCH([Changes - New value], "[0-9]+") AND REGEXP_MATCH([Changes - Previous value], "[0-9]+"))
THEN(NUMBER([Changes - New value])-NUMBER([Changes - Previous value]))/60/60
ENDIF
ENDIFTip: If you're working in a language other than English, see this article to help you enter Explore formulas in your language. - Click Save.
- (Optional) Determine which aggregators should be available for the metric. For additional help, see Setting a metric's default and visible aggregators.
- In the Metrics panel, click Add.
- From the list of attributes, expand the Calculated metrics folder, find your calculated metric, then click the pencil icon () next to it.
- In the top-right corner of the Standard calculated metric panel, click Options > Edit aggregators.
- Set the following aggregators as visible: SUM, AVG, MIN, MAX, and MED.
- (Optional) Change the default aggregator.
- Click Save.
- (Optional) Customize the metric's display format. For additional help, see Customizing the result format.
- In the Metrics panel, click Add.
- From the list of attributes, expand the Calculated metrics folder, find your calculated metric, then click the pencil icon () next to it.
- In the top-right corner of the Standard calculated metric panel, click Options > Edit display format.
- In the first drop-down, select Custom.
- Customize the metric's display format as needed. For example, you could add the suffix "min" or "hrs," or increase the number of decimal places.
- Click Save.
Now that you've created your standard calculated metric, you can use it in other reports in the Support: Updates history dataset. See below for an example report.
Measuring update handling time by agent
In this example report, you'll use the standard calculated metric you created above to produce a graph showing agents with the top ten average handling time.
To create the report
- In Zendesk Explore, click the Reports () icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Updates history, then click New report. The report builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, select Calculated metrics > Update handling time (min) (or whatever you named the metric you created above), then click Apply.
- Change the metric aggregator to AVG, if it's not already.
- In the Columns panel, click Add.
- From the list of attributes, select Updater > Updater name, then click Apply.
- In the Filters panel, click Add.
- From the list of attributes, select Updater > Updater role, then click Apply.
- Click the Updater role attribute you just added, select Admin and Agent , then click Apply.
- In the Filters panel, click Add.
- From the list of attributes, select Time - Ticket update > Update - Date, then click Apply.
- Click the Update - Date attribute you just added and filter by the time period you want to see. For help, see Filtering by an attribute in the Filters panel.
- From the Visualization type menu (), select Bar.
- (Optional) Show only the top ten users. For additional information, see Creating a top/bottom filter.
- Click the Result manipulation menu () and select Top/bottom.
- In the Top/bottom panel, select Top and set the number to 10.
- Click Apply.
- (Optional) Adjust the chart colors, labels, and more using the Chart configuration menu (). For help, see Customizing your chart.
You'll end up with a chart that looks something like the following: