Explore recipe: Reporting on the volume of tickets generated by group each hour

What's my plan?

Suite

Professional, Enterprise, or Enterprise Plus

Support with

Explore Professional or Enterprise

In this recipe, you'll learn how to create a report that shows the volume of tickets generated in each group, by the hour, in a set range of time.

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

1. In Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Support > Support - Tickets dataset, then click Start report. The report builder opens.
4. Under Metrics, add Tickets > Tickets.
5. Select D_COUNT for the aggregator.
6. Under Columns, select Ticket > Ticket group.
7. Under Rows, select Time - Ticket created > Ticket created - hour.

The resulting report should look like this:

You can edit the Ticket created - Date filter at the top of the report and change the time range to six months in the past, or any other time range you want to display. To exclude groups, select the Ticket group attribute under Columns, and choose which groups you want to appear.

For related information, see these articles:

• Tickets by time of day created
• Why can't I see the most recent month on the "Tickets created by month/year" report?