Explore recipe: First priority value of a ticket

This Explore recipe shows you how to report on the initial priority of a ticket. Even if the ticket's priority was later changed or downgraded, you can still report on the first priority value that was set on the ticket.

What you'll need

Skill level: Easy

Time required: 5 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving users access to Explore)
• Ticket data in Zendesk Support

Building your report

In the example report below, you'll create a standard calculated metric that returns tickets that have had an initial priority set. You'll then filter the results by the value of priority field to find tickets that originated in the Urgent priority.

This is helpful if you want to track the number of urgent tickets received in a given time period, regardless of whether an agent or end user downgraded the ticket later on.

To create the report

1. In Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Support - Updates history, then click Start report. The report builder opens. 
4. In the Calculations () menu, click Standard calculated metric.
5. In the Name field, enter a name for your metric, such as Initial Priority.
6. In the Formula editor, enter or paste the following:
   

   IF ([Changes - Field name]="priority" AND [Changes - Previous value]=NULL)  
   THEN [Update ID]
   ENDIF

   Your standard calculated metric will look like the following image:
   
7. Click Save.
8. In the Metrics pane, add the standard calculated metric you just created and click Apply.
9. Change the metric aggregator to D_COUNT. This shows you the number of tickets that have had an initial priority set.
10. In the Filters pane, add Changes - Field name and filter that attribute by the priority value. This improves the load time of your report by limiting the results of the next step to the Priority field.
11. In the Rows pane, add the following attributes:
    • Ticket ID
    • Changes - New value
12. Click the Changes - New value attribute you just added and filter it by the urgent value.
13. Add a metric filter and set it to 1.

The report is now complete and shows only the tickets that started in the urgent priority.