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


What's my plan?





All Suites

Professional, Enterprise, or Enterprise Plus









Support with

Explore Professional or Enterprise





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




In Zendesk Explore, click the Reports ( ) icon.
In the Reports library, click New report.
On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
In the Metrics panel, click Add.
From the list of metrics, select Tickets > Tickets, then click Apply. Ensure the aggregator for this metric is set to D_COUNT.
In the Columns panel, click Add.
From the list of attributes, select Time - Ticket created > Ticket created - Hour, then click Apply.
Click the attribute you just added, then click Edit date ranges and select the Advanced tab.
Set the following criteria:


From the beginning of | 8 hours in the past


To the end of | This hour



In the Filters panel, click Add.
From the list of attributes, select Ticket > Ticket channel, then click Apply.
Click the filter you just added, select only Messaging as the filter, then click Apply.
In the visualization type menu ( ), click Column. Explore displays a column chart showing all messaging tickets created over the last eight hours.
To show the number of tickets above each column, go to the Chart configuration menu ( ) and click Display format > Edit displayed values.
In the Show value field, select Show.
Give the report a descriptive name and click Save.


{
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408839132954",
"url": "https://support.zendesk.com/hc/en-us/articles/4408839132954-Explore-recipe-Conversations-created-each-hour-for-the-last-eight-hours",
"headline": "Explore recipe: Conversations created each hour for the last eight hours",
"description": "You can create a report to track the number of messaging conversations created each hour over the last eight hours using the report builder and specific filters for time and channel.",
"articleSection": "Messaging reporting recipes",
"datePublished": "2021-10-16T05:34:52+00:00",
"dateModified": "2025-09-06T00:06:39+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408839132954"
},
"author": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"publisher": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"isPartOf": {
"@type": "WebSite",
"name": "Zendesk Help",
"@id": "https://support.zendesk.com/hc/"
},
"about": {
"@type": "SoftwareApplication",
"name": "Zendesk",
"@id": "https://www.zendesk.com",
"softwareAddOn": {
"@type": "SoftwareApplication",
"name": "Explore",
"@id": "https://support.zendesk.com/hc/en-us/sections/4405298856346"
}
}
}