Explore recipe: Auditing a random selection of tickets


What's my plan?





All Suites

Professional, Enterprise, or Enterprise Plus









Support with

Explore Professional or Enterprise





Explore is designed to slice and dice data by categories and fields, but sometimes you need a random selection of tickets to undertake an audit. This recipe uses the Support: Tickets dataset to pull a random selection of tickets, which you can then use to audit individual agents or ticket groups.
Note: Random results are generated when the report is loaded for the first time. If you reload it the same results will be returned until the next data refresh.
This article contains the following topics:

What you'll need
Returning a random selection of tickets
Auditing individual agents
Auditing ticket groups
Next steps

What you’ll need
Skill level: Intermediate
Time required: 15 minutes

Zendesk Explore Professional or Enterprise
Editor or Admin permissions (see Giving agents access to Explore)
Ticket data in Zendesk Support

Returning a random selection of tickets

In 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.
Click the Calculations ( ) menu > Standard calculated metric.
Name this metric Random.
In the Formula field, enter the following:
RANDOM()
Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language.

Click Save.
Apply any necessary filters, like date range, group, channel, or satisfaction rating.
In the Metrics panel, click Add and add your calculated metric.

From here, you can audit individual agents or entire ticket groups, depending on your needs.
Auditing individual agents

In the Rows panel, click Add and add Assignee name.
Next to Filters, click Add and add Assignee role.
Click the Assignee role filter (the gray box) and select Agent and/or Admin as appropriate based on your auditing needs.
From the Result manipulation ( ) menu, select Top/bottom.
In the Top field, specify how many results you want per assignee.
In the Strategy field, select Per block on rows.

In the Rows panel, click Add and add Ticket ID. This gives you a "top X" tickets per person based on your random metric.
Note: Adding any other metric or attribute will change the ticket IDs displayed.



From here, you can click the ticket ID and select Open link to look at the ticket. Alternatively, you can click the drop-down arrow next to Save and choose Export to create a CSV or Excel file with your results.
Auditing ticket groups

In the Rows panel, click Add and add Ticket group.
From the Result manipulation ( ) menu, select Top/bottom.
In the Top field, specify how many results you want per group.
In the Strategy field, select Per block on rows.
In the Rows panel, click Add and add Ticket ID. This gives you a "top X" tickets per group based on your random metric.
Note: Adding any other metric or attribute will change the ticket IDs displayed.



From here, you can click the ticket ID and select Open link to look at the ticket. Alternatively, you can click the drop-down arrow next to Save and choose Export to create a CSV or Excel file with your results.
Next steps
For more information about the metrics and attributes you can use with the Tickets dataset, see Metrics and attributes for Zendesk Support. {
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4409693231514",
"url": "https://support.zendesk.com/hc/en-us/articles/4409693231514-Explore-recipe-Auditing-a-random-selection-of-tickets",
"headline": "Explore recipe: Auditing a random selection of tickets",
"description": "You can generate a random selection of tickets from your support data to audit individual agents or ticket groups by creating a report with a calculated random metric and applying filters as needed.",
"articleSection": "Ticket reporting recipes",
"datePublished": "2021-10-28T19:11:45+00:00",
"dateModified": "2025-09-06T00:03:28+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4409693231514"
},
"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"
}
}
}