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

<div class="article-banners">
<div id="docs-wmp-link"><a href="https://support.zendesk.com/hc/en-us/articles/5411234991258-plan" rel="noopener" target="_blank">What's my plan?</a></div>
<div class="article-banner" id="suite_pee">
<table>
<tbody>
<tr>
<td>
<strong>All Suites</strong>
</td>
<td>Professional, Enterprise, or Enterprise Plus</td>
</tr>
</tbody>
</table>
</div>
<div class="article-banner" id="support_with_explore_pe">
<table>
<tbody>
<tr>
<td>
<strong>Support with</strong>
</td>
<td>Explore Professional or Enterprise</td>
</tr>
</tbody>
</table>
</div>
</div>
<p>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 <a href="https://support.zendesk.com/hc/en-us/articles/4408846454682" rel="undefined" target="_self">About messaging</a>.</p>
<div aria-labelledby="ariaid-title2" class="topic nested1" id="topic_jnt_j3y_4fb">
<h2 class="title topictitle2" id="ariaid-title2">What you'll need</h2>
<div class="body">
<p class="p"><strong>Skill level:</strong><span> Intermediate</span></p>
<p class="p"><strong>Time required:</strong><span> 10</span> minutes</p>
<ul class="ul" id="topic_jnt_j3y_4fb__ul_uvf_jkp_2fb">
<li class="li">Zendesk Explore Professional or Enterprise</li>
<li class="li">Editor or Admin permissions (see<span> </span><a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408836002970-Adding-users-to-Explore" rel="noopener" target="_blank">Giving users access to Explore</a>)</li>
<li class="li">Conversations in Zendesk messaging</li>
</ul>
<p><span style="font-size: 1.5em; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif;">Creating the report</span></p>
</div>
</div>
<div aria-labelledby="ariaid-title3" class="topic nested1" id="topic_kd2_klp_2fb">
<ol>
<li class="li">In Zendesk Explore, click the Reports (<span> </span><img alt="" class="image" id="topic_kd2_klp_2fb__image_l1h_stp_2fb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_query_icon.png" width="16">) icon.</li>
<li class="li">In the Reports library, click<span> </span><strong class="ph b">New report</strong>.</li>
<li class="li">On the <strong>Select a dataset</strong> page, click <strong>Support</strong> &gt;<strong> Support -</strong> <strong>Tickets</strong>, then click<strong> Start report</strong>. The report builder opens.</li>
<li>In the <strong>Metrics</strong> panel, click <strong>Add</strong>.</li>
<li>From the list of metrics, select <strong>Tickets</strong> &gt; <strong>Tickets</strong>, then click <strong>Apply</strong>. Ensure the aggregator for this metric is set to <strong>D_COUNT</strong>.</li>
<li>In the <strong>Columns</strong> panel, click <strong>Add</strong>.</li>
<li>From the list of attributes, select <strong>Time - Ticket created</strong> &gt; <strong>Ticket created - Hour</strong>, then click <strong>Apply</strong>.</li>
<li>Click the attribute you just added, then click <strong>Edit date ranges</strong> and select the <strong>Advanced</strong> tab.</li>
<li>Set the following criteria:
<ul>
<li>
<strong>From the beginning of</strong> | <strong>8 hours in the past</strong>
</li>
<li>
<strong>To the end of</strong> | <strong>This hour</strong>
</li>
</ul>
</li>
<li>In the <strong>Filters</strong> panel, click <strong>Add</strong>.</li>
<li>From the list of attributes, select <strong>Ticket</strong> &gt; <strong>Ticket channel</strong>, then click <strong>Apply</strong>.</li>
<li>Click the filter you just added, select only <strong>Messaging</strong> as the filter, then click <strong>Apply</strong>.</li>
<li class="li">In the visualization type menu (<img alt="" class="image" id="topic_zbp_dhs_hlb__image_cr3_knt_hlb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_visualization_type.png">), click<strong> Column</strong>. Explore displays a column chart showing all messaging tickets created over the last eight hours.</li>
<li class="li">To show the number of tickets above each column, go to the <strong>Chart configuration</strong> menu (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_chart_configuration.png">) and click <strong>Display format</strong> &gt; <strong>Edit displayed values</strong>.</li>
<li class="li">In the <strong>Show value</strong> field, select <strong>Show</strong>.</li>
<li>Give the report a descriptive name and click <strong>Save</strong>.</li>
</ol>
<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/explore_recipe_messaging_conversations_created_last_8_hours.png" width="850">
</div><script id="docs-schema-markup" type="application/ld+json">{
"@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"
}
}
}</script>