Explore recipe: Count of agent interactions with tickets

<div class="body">
<div class="article-banners">
<div id="docs-wmp-link"><a href="https://support.zendesk.com/hc/en-us/articles/5411234991258-plan" target="_blank" rel="noopener noreferrer">What's my plan?</a></div>
<div class="article-banner" id="suite_pee"><p><strong>All Suites</strong> Professional, Enterprise, or Enterprise Plus</p></div>
<div class="article-banner" id="support_with_explore_pe"><p><strong>Support with</strong> Explore Professional or Enterprise</p></div>
</div>
<p>In this Explore recipe, you'll learn how to create a report to show the number of tickets each agent updated for a specific date range.</p>
</div><div class="topic nested1" id="topic_xbd_43y_4fb" aria-labelledby="ariaid-title2">
<h2 id="ariaid-title2">What you'll need</h2>
<div class="body">
<p dir="ltr"><strong>Skill level:</strong> Beginner</p>
<p dir="ltr"><strong>Time required:</strong> 15 minutes</p>
<ul>
<li dir="ltr" data-list-item-id="e08730c234ab2fe8617b12dd71eecc908">Zendesk Explore Professional or Enterprise</li>
<li dir="ltr" data-list-item-id="e1ec0086b5c79a293ad43e210f32fa9db">Editor or admin permissions (see <a href="https://support.zendesk.com/hc/en-us/articles/4408836002970" target="_blank" rel="noopener noreferrer">Giving users access to Explore</a>)</li>
<li dir="ltr" data-list-item-id="e82ca3cc9d4b25f7adb466ef6aa142a9f">Ticket data in Zendesk Support</li>
</ul>
</div>
</div><div class="topic nested1" id="topic_nmw_43y_4fb" aria-labelledby="ariaid-title3">
<h2 id="ariaid-title3">How to create the report in Explore</h2>
<div class="body"><div class="section" id="topic_nmw_43y_4fb__section_ddd_2dl_4fb">
<p>To create this report in Explore:</p>
<ol>
<li data-list-item-id="ea53ba82f21448228701c315cc2630258">In Explore, click the reports (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_query_icon.png" alt="" width="16" id="topic_w1m_k1m_rhb__image_l1h_stp_2fb">) icon</li>
<li data-list-item-id="e1247bb7ebced925dc05127d901107fee">In the Reports library, click <strong class="ph b">New report</strong>
</li>
<li data-list-item-id="ea56637ca9748597c490a200e5ed88036">On the <strong>Select a dataset</strong> page, click <strong>Support</strong> &gt; <strong>Support - Updates history</strong>, then click <strong class="ph b">Start report</strong>
</li>
<li data-list-item-id="e8e87031ee146df631f96496049d8a7cc">The report builder opens, and from the <strong>Metrics</strong> panel, click <strong>Add</strong>
</li>
<li data-list-item-id="e2ccb0d15ccbb4408442ded573b6a6578">From the list of metrics, choose <strong>Tickets</strong> &gt; <strong>Tickets updated</strong> and click <strong>Apply</strong>
</li>
<li data-list-item-id="e69b8f50f525964b96a67d851427e3cf1">In the <strong>Rows</strong> panel, click <strong>Add</strong>
</li>
<li data-list-item-id="efeeae0f82e9fa8f6558d2a32553de685">From the list of attributes, choose <strong>Updater</strong> &gt; <strong>Updater name</strong>, then click <strong>Apply</strong>
</li>
<li data-list-item-id="e1859c500bc592cdf138a171c3d24499f">In the <strong>Filters panel</strong>, click <strong>Add</strong>
</li>
<li data-list-item-id="ecaf9c3316d119ed216ec8bbbd387ee85">From the list of attributes, choose <strong>Updater</strong> &gt; <strong>Updater role</strong>, then click <strong>Apply</strong>
</li>
<li data-list-item-id="eda87d84b525897b1c60500583e5d7d70">Click the <strong>Updater role</strong> filter you just added, and on the <strong>Selected</strong> tab, select <strong>Admin</strong> and <strong>Agent</strong>
</li>
<li data-list-item-id="e1ca798c56a0c20d47c5e3cb065f3581e">Click <strong>Apply</strong>
</li>
<li data-list-item-id="e7c92b30ba409e974f1376472c5e6e801">In the <strong>Filters panel</strong>, click <strong>Add</strong>
</li>
<li data-list-item-id="eb2decd235e3a5e6c8caf9192ff3a1d40">From the list of attributes, choose <strong>Time - Ticket update</strong> &gt; <strong>Update - Date</strong>, then click <strong>Apply</strong>
</li>
<li data-list-item-id="e292916afd2fca81f16ecb66eedd9662d">Click the <strong>Update - Date</strong> filter you just added, and specify the date you want to see. Click <strong>Edit date ranges</strong> at the bottom of the page if you want to see more date range options</li>
<li data-list-item-id="e18f03033a78e36a23ef383ee704263e6">Click <strong>Apply</strong>
</li>
<li data-list-item-id="ec8c004bb778ee5825aab8a3c6dbc225a">By default, Explore chooses a column chart to best display the data. To change this, click the Visualization type (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_visualization_type.png" alt="" width="16" id="topic_kd2_klp_2fb__image_snq_ccq_2fb">) icon, then choose <strong>Table</strong>. You'll see something resembling the following table:<br><img src="https://support.zendesk.com/hc/article_attachments/7856563517210" alt="" width="500px" height="483">
</li>
<li data-list-item-id="e42231f63cda477c7fbe0c5ce55e6b17a">The report is named <strong class="ph b">New report</strong> by default, click the <strong class="ph b">New report</strong> text and replace it with a title of your own</li>
<li data-list-item-id="eda2577495fb1cc0260468e92fc340155">Click <strong class="ph b">Save</strong>
</li>
</ol>
</div></div>
</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/4408846302490",
"url": "https://support.zendesk.com/hc/en-us/articles/4408846302490-Explore-recipe-Count-of-agent-interactions-with-tickets",
"headline": "Explore recipe: Count of agent interactions with tickets",
"description": "You can create a report to display the number of tickets each agent has updated within a specified date range using the report builder in Explore.",
"articleSection": "Ticket reporting recipes",
"datePublished": "2021-10-16T05:28:01+00:00",
"dateModified": "2025-09-06T00:03:51+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408846302490"
},
"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>