This recipe enables you to report on the first reply time (or other resolution time metrics) grouped by specific ticket tags.
This article contains the following topics:
What you'll need
Skill level: Intermediate
Time required: 15 mins
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
Creating the query
- In Explore, click the query () icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Support > Tickets > Support: Tickets, then click Apply. Query builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, choose Duration between events - Calendar hours (min) > First reply time (min), then click Apply
- In the Metrics panel, click the First reply time (min) metric you just added and select an aggregator (AVG, SUM, etc.) for the calculation you want.
- In the Rows panel, click Add.
- From the list of attributes, choose Ticket > Ticket Tags, then click Apply.
- The current query setup will look like this:
The query is now complete. See the screenshot below for an example of the finished result with a list of ticket tags and their associated first reply time.
Enhancing your report
As you learned, the First reply time metric can be swapped to accommodate any other resolution time metrics (for example, First resolution time or Full resolution time). You can also use different graphs or charts to help visualize the data. See below for examples on how to change the visualization for the results.
- From the visualization type () menu, choose the Column chart type.
- In the query row selector, click Ticket Tags to display all brackets on the column graph, or click a specific tag name to only display data for that ticket tag.
- From the visualization type () menu, choose the Pie chart type.
- Move theTicket Tags attribute from the Rows panel to the Columns panel.
The results will now be display as a pie chart. By default, the pie chart will display the data (FRT values) as well as their respective percentages.