Nesting your field options is a great way to organize your custom drop-down fields for your end users and agents. Reporting on these fields can be difficult, and you might find yourself struggling to report on each level within the field.
This article will help you understand why reporting on nested drop-down fields can be difficult and how you can overcome these obstacles using a custom metric.
This article contains the following sections:
How Insights sees nested drop-down fields
In short, what you see is not exactly what Insights receives. When you build your nested drop-down fields, you are essentially telling the UI to present the options as selectable choices. In practice, Insights only works with what it's given, so Insights uses exactly what you put in the title and tag fields of your drop-down options.
As you probably noticed when you were building out your fields, each custom drop-down option has a title and a corresponding tag. The entire field option title, including the colons, is carried over to Insights exactly as you created. The field title is brought over as an attribute and the field option title is brought over as one attribute label.
For example, the images below demonstrate how the drop-down field options in the Organizing drop-down list options article will be translated into Insights.
The image below adds the Camera Model custom field as an attribute from the How panel. The data is sliced by each field option title.
If you want to see how many tickets came in for Digital SLR Cameras for example, you can use the custom metric in the section below.
Creating your custom metric
You will need to tell Insights to only give you the number of tickets there are based on a portion of the attribute label. You can achieve this by creating custom metrics.
Within the metric editor, you want to create a filter metric using the LIKE clause. GoodData has a great article on how to use the LIKE clause (see Filtering with the LIKE clause). This custom metric uses the LIKE clause to create a filter with the % wildcard.
To create your custom metric
- In the What panel, click the (advanced) link next to Add New Metric.
- Select Custom metric.
- Enter the following formula:
- SELECT # Tickets WHERE Custom Attribute Label <Field Title> [<Field Title>] LIKE "%<partial_attribute_label>%"
Note: You cannot copy and paste the formula, you must select the items below from the folders in the Elements drop-down list.- # Tickets is in Metrics.
- Custom Attribute Label <Field Title> [<Field Title>] is in Attribute labels > Field title. The Field title folder will be your custom field name.
-
Substitute <partial_attribute_label> with the drop-down option you would like to report on. This is a case-sensitive character string.
The example above would use the following metric:
- SELECT # Tickets WHERE Custom Attribute Label Camera Model? [Camera Model] LIKE "%Consumer%"
If you use this custom metric for every nested drop-down level you want to report on, your report will look like the image below.
Alternative solutions
The benefit of the above solution is that you can report on the attributes already available in your Zendesk without having to make any modifications to your workflow. If you want to use more conventional reporting methods, see the Conditional Fields app. This enables you to create unique fields, and the app will determine how your fields appear. When you use unique drop-down fields rather than nesting within one drop-down, you can report on the fields as individual attributes rather than creating custom metrics.
39 Comments
Hey Bettina,
I'm going to respond to your question on Stephen's behalf.
I was able to replicate the process to find Custom Attribute Label <Field Title> [<Field Title>].
In case you still run into issues, please feel free to email us at support@zendesk.com with screenshots of what you see. This will allow us to take a closer look into what might be going on.
Thanks,
Dipesh
Hello,
This is a great recipe, thank you very much.
My question: I have 5 nested fields (categories), each of them has multiple subcategories.
E.g.: A (A1, A2, A3..), B (B1, B2, B3...) and so on
Is it possible to display in one bar chart report # of tickets per each of 5 fields so that I also see how many tickets per subcategory sit within each field? So that these subcategories create a stacked bar?
I hope I'm explaining myself well.
Thanks!
Hi all,
I tryed this method without succes :
Here is my Metric :
SELECT % Satisfaction Score WHERE Custom Attribute Label Module [Module] LIKE "%<Learning>%"
Of course, I have Satisfaction Scores for theses tickets....
Any idea to help me ?
Thanks !
Hi Sophie! Sorry for the delayed response!
The most likely culprit here is that Insights needs to sync with Zendesk before that data will actually show up. Is the data still not appearing, or has this resolved?
Thanks for letting us know, Sophie!
I can't seem to find a Recipe for this in the Explore Help Center. We want to start using the About Fields and Nested Drop-down Fields, but are not sure how to report on them in Explore.
Following up on Judd's question, wondering if reporting on nested drop downs is feasible in explorer? Thanks! This article is super helpful but I don't have the ability to create reports in insight (only in Explorer)
Thanks yall!
Chris
In Explore, you can create a custom metric:
Ensure you use the aggregate COUNT.
Explore does give you more options for this kind of analysis. This article shows how to group together common items such as nested custom fields or support groups.
Thanks for weighing in, Graeme!
Chris, hopefully that provides the kind of know-how you need to make things happen on the Explore platform!
Keep us posed if you have any other questions and thanks again.
Please sign in to leave a comment.