Explore recipe: Reporting on the number of reopened tickets per day

What's my plan?

In this recipe, you'll learn how to create a report that shows the number of tickets that were reopened in your account per day.

This article contains the following topics:

• What you'll need
• Creating the report

What you'll need

Skill level: Beginner

Time required: 5 minutes

• Zendesk Explore Professional or Enterprise
• Editor or admin permissions (see Giving users access to Explore)

Creating the report

You can use the Reopened tickets metric and the Ticket Solve date attribute to show the number of reopened tickets per day.

1. In Explore, click the Reports ( ) icon.
2. In the report library, click New report.
3. On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
4. In the Metrics panel, click Add.
5. From the list of metrics, select Tickets > Reopened tickets, then click Apply.
6. In the Rows panel, select the Ticket solved - Date attribute, then click Apply.
7. In the Filters panel, select the Ticket created - Date filter, and choose a time filter for a small period of time, such as a week or month. This prevents the query from timing out while you're building it. The example screenshot below shows an example of this report: