Explore recipe: Conversations created each hour for the last eight hours

What's my plan?

In this recipe, you'll learn how to use the information that Explore collects from the messaging channel to understand how many conversations have been created in the last eight hours. For more information, see About messaging.

What you'll need

Skill level: Intermediate

Time required: 10 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving users access to Explore)
• Conversations in Zendesk messaging

Creating the report

1. In Zendesk Explore, click the Reports ( ) icon.
2. In the Reports 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 > Tickets, then click Apply. Ensure the aggregator for this metric is set to D_COUNT.
6. In the Columns panel, click Add.
7. From the list of attributes, select Time - Ticket created > Ticket created - Hour, then click Apply.
8. Click the attribute you just added, then click Edit date ranges and select the Advanced tab.
9. Set the following criteria:
   • From the beginning of | 8 hours in the past
   • To the end of | This hour
10. In the Filters panel, click Add.
11. From the list of attributes, select Ticket > Ticket channel, then click Apply.
12. Click the filter you just added, select only Messaging as the filter, then click Apply.
13. In the visualization type menu (), click Column. Explore displays a column chart showing all messaging tickets created over the last eight hours.
14. To show the number of tickets above each column, go to the Chart configuration menu () and click Display format > Edit displayed values.
15. In the Show value field, select Show.
16. Give the report a descriptive name and click Save.