Explore recipe: How many tickets has a user submitted?

<div class="body">
<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>
<div class="p"><span>This Explore recipe shows you how to report on how many tickets have been submitted by a user or certain users.<br><br></span></div>
</div>
<div aria-labelledby="ariaid-title2" class="topic nested1" id="topic_xbd_43y_4fb">
<h2 class="title topictitle2" id="ariaid-title2">What you'll need</h2>
<div class="body">
<p class="p" dir="ltr">Skill level: <em>Easy</em></p>
<p class="p" dir="ltr">Time Required: 10 minutes</p>
<ul>
<li class="p" dir="ltr">Zendesk Explore Professional or Enterprise</li>
<li class="p" dir="ltr">Editor or Admin permissions (see <a class="xref" href="https://support.zendesk.com/hc/en-us/articles/4408836002970-Adding-users-to-Explore" rel="noopener" target="_blank"><u class="ph u">Adding users to Explore</u></a>)</li>
<li class="p" dir="ltr">Ticket and customer data in Zendesk Support<br><br>
</li>
</ul>
</div>
</div>
<div aria-labelledby="ariaid-title3" class="topic nested1" id="topic_nmw_43y_4fb">
<h2 class="title topictitle2" id="ariaid-title3">How to create the report in Explore</h2>
<p><iframe allowfullscreen="" frameborder="0" height="315" src="//www.youtube-nocookie.com/embed/ikaOu7qc4XM" width="560"></iframe></p>
<div class="body">
<ol class="ol" id="topic_nmw_43y_4fb__ol_abn_gjy_4fb"></ol>
<div class="section" id="topic_nmw_43y_4fb__section_ddd_2dl_4fb">
<p class="p"><strong>Use the following steps to create this report in Explore:</strong></p>
<ol class="ol" id="topic_vpv_23y_4fb__ol_und_wqx_4fb">
<li class="li" dir="ltr">In Explore, click the reports (<span> </span><img alt="" class="image" height="16" id="topic_vpv_23y_4fb__image_vnd_wqx_4fb" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_query_icon.png" width="16">) icon.</li>
<li class="li" dir="ltr">In the Reports library, click<span> </span><strong class="ph b">New report</strong>.</li>
<li class="li" dir="ltr">On the<span><strong> Select</strong> </span><strong class="ph b">a dataset</strong><span> </span>page, click<span> </span><strong>Support</strong><span> </span>&gt;<span><strong> Support -</strong> </span><strong>Tickets</strong>, then click<strong> Start</strong><strong class="ph b"> report</strong><strong>. </strong>The report builder opens.</li>
<li class="li" dir="ltr">In the<span> </span><strong class="ph b">Metrics</strong><span> </span>panel, click<span> </span><strong class="ph b">Add</strong>.</li>
<li class="li" dir="ltr">From the list of metrics, choose <strong>Tickets </strong>&gt;<strong> Tickets</strong>, then click <strong>Apply</strong>. <span>Notice that </span><span></span><strong>COUNT(Tickets)</strong><span> is displayed in the </span><span></span><strong>Metrics</strong><span> panel and Explore automatically displays the count of tickets in the main section of the page.</span>
</li>
<li class="li">Next, add the attribute that will display the number of tickets for each ticket requester (i.e. someone who's opened a ticket). In the <span></span><strong>Rows </strong><span>section, click <span></span></span><strong class="ph b">Add</strong><span>.</span>
</li>
<li class="li" dir="ltr">From the list of attributes, choose <strong>Requester/user </strong>&gt;<strong> Requester name</strong> and <strong>Requester/user</strong> &gt; <strong>Requester email</strong>, then click<span> </span><strong class="ph b">Apply. </strong>Explore displays each ticket requester, their email address, and the number of tickets they have opened.</li>
<li class="li" dir="ltr">Optionally, from the list of attributes, you may want to choose an attribute under <strong>Time - ticket created </strong>or <strong>Time - ticket solved</strong>, which will allow you to slice this data by week or month, for example.</li>
<li class="li" dir="ltr">If you want to display only end user tickets or agent tickets, add a filter to the report. In the <span></span><strong>Filters </strong><span></span>section, click <span></span><span></span><strong class="ph b">Add</strong>. From the list of attributes, choose <strong class="ph b">Requester/user <span></span><span></span></strong>&gt; <span></span><strong>Requester </strong><strong class="ph b"><span></span>role</strong>, then click <span></span><strong class="ph b">Apply. </strong>Click the filter you just added. Then, from the list of values, choose <span></span><strong>End-user</strong>. If you want to display tickets requested by agents, click <span></span><strong>Agent</strong>.<br>You'll end up with a report that looks similar to the following:<br><img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_recipe_tickets_submitted_by_user.png" width="850">
</li>
<li class="li" dir="ltr">Finally, <strong>Save</strong> your new report.</li>
</ol>
<p>Add your report to a <a href="https://support.zendesk.com/hc/en-us/articles/4408827904794-Adding-reports-to-dashboards" rel="noopener" target="_blank">dashboard</a> to share it with your customers. For more information, see the article: <a href="https://support.zendesk.com/hc/en-us/articles/4408826905626-Sharing-Explore-dashboards-outside-Zendesk" rel="noopener" target="_blank">Sharing Explore dashboards outside of Zendesk</a>.</p>
<p> </p>
</div>
</div>
</div>
<p>
</p><script id="docs-schema-markup" type="application/ld+json">{
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408826807706",
"url": "https://support.zendesk.com/hc/en-us/articles/4408826807706-Explore-recipe-How-many-tickets-has-a-user-submitted",
"headline": "Explore recipe: How many tickets has a user submitted?",
"description": "You can create a report to see how many tickets each user has submitted by using the report builder to count tickets and group them by requester name and email, with optional filters for requester roles and time periods.",
"articleSection": "Ticket reporting recipes",
"datePublished": "2021-10-16T03:28:26+00:00",
"dateModified": "2025-09-06T00:04:54+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408826807706"
},
"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>