Reporting on Level 3 Fields in Nested Drop-Downs
How do I report on Level 3 fields in a nested drop-down list?
To report on Level 3 fields, create a standard calculated attribute called 'List level three'. Use the formulaREGEXP_EXTRACT([YourFieldName],"(?<=^[^:]*::[^:]*::)([^:]*)"). This extracts the text from the second '::' to the end of the string, allowing you to focus on the third level of your nested drop-down list.
More related questions
How do I create a nested drop-down list in Zendesk Support?
Creating a nested drop-down list in Zendesk Support is straightforward. First, navigate to the Admin menu and select Manage > Ticket Fields. Click 'Add field' and choose 'Drop-down' as the field type. Enter a name for the field under 'Title shown…
What do I need to start reporting on nested drop-down fields in Zendesk Explore?
To report on nested drop-down fields in Zendesk Explore, you'll need a few things. Ensure you have Zendesk Explore Professional or Enterprise, Editor or Admin permissions, ticket data in Zendesk Support, and some experience with Explore….
How can I create an initial report for a custom drop-down field in Zendesk Explore?
To create an initial report for a custom drop-down field in Zendesk Explore, start by clicking the reports icon and selecting 'New report'. Choose 'Support > Support - Tickets' as your dataset and click 'Start report'. In the Metrics panel, add…
How do I report on Level 1 fields in a nested drop-down list?
To report on Level 1 fields in a nested drop-down list, create a standard calculated attribute in Zendesk Explore. Open the calculations menu and select 'Standard calculated attribute'. Name it 'List level one' and use the formula…
How can I extract Level 2 fields from a nested drop-down list in Zendesk Explore?
To extract Level 2 fields from a nested drop-down list, create a standard calculated attribute named 'List level two'. Use the formulaREGEXP_EXTRACT([YourFieldName],"(?<=^[^:]*::)([^:]*)"). This formula captures the text between the first and…
Can I report on more than three levels in a nested drop-down list?
Yes, you can report on more than three levels in a nested drop-down list by extending the formula used for Level 3. For each additional level, adjust the formula to capture the desired section of the string. For example, for Level 4, use…
How can I exclude certain tags from my Zendesk Explore reports?
To exclude specific tags from your Zendesk Explore reports, open your query and add 'ticket tags' under 'filters'. Type the tag you want to exclude, such as 'closedbymerge', and ensure 'Excluded' is selected. This will filter out tickets with the…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
