Explore recipe: Reporting on tickets with similar tags


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 report on tickets with similar tags that include a certain word or string. This is useful for grouping your ticket tags and seeing how many tickets have similar types of tags.
This recipe involves creating a custom attribute to group your tags into different categories using the CONTAINS function, which serves as a great alternative to creating a group attribute from ticket tags.
Before, without grouping:
After, with grouping:

This article contains the following topics:

What you’ll need
Creating the report

What you’ll need
Skill level: Intermediate
Time required: 10 mins

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

Creating the report

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.
In the Metrics panel, click Add.
From the list, select Tickets, then click Apply. Change the aggregator to D_COUNT.

Tip: You can also add the Solved tickets and Unsolved tickets metrics to further break down the count of total tickets in your report.

In the Calculations menu ( ), click Standard calculated attribute.
In the Name field, give your attribute a name like Tag grouping.
In the Formula field, enter or paste the following formula to look for ticket tags containing a certain word and label them as a group. Replace “option” and “test” with any word or phrase to match on different tags.
IF (CONTAINS([Ticket tags],"option")) THEN "Option-related tags" ELIF (CONTAINS([Ticket tags],"test")) THEN "Test-related tags" ELSE "Other tags" ENDIF

When you’re finished, click Save.
In the Rows panel, click Add.
From the list, select Tag grouping (the standard calculated attribute you created), then click Apply.
(Optional) Update the default Ticket created - Date filter to narrow your results to a specific timeframe.
{
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4419348849434",
"url": "https://support.zendesk.com/hc/en-us/articles/4419348849434-Explore-recipe-Reporting-on-tickets-with-similar-tags",
"headline": "Explore recipe: Reporting on tickets with similar tags",
"description": "You can create a report that groups tickets by similar tags containing specific words using a custom attribute with the CONTAINS function to analyze ticket tag categories.",
"articleSection": "Ticket reporting recipes",
"datePublished": "2022-02-03T20:46:54+00:00",
"dateModified": "2025-09-06T00:03:25+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4419348849434"
},
"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"
}
}
}