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, useREGEXP_EXTRACT([YourFieldName],"(?<=^[^:]*::[^:]*::[^:]*::)([^:]*)")
. This approach allows you to analyze deeper levels of your nested drop-down list.
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…
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….
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…
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…
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…
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,…
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…