This article contains the following sections:
Creating custom groups
Explore’s custom groups provide more flexibility for understanding your team’s performance. For example, you can create groups for all of your internal teams’ functions and external facing teams’ functions to use as attributes or filters in your analysis. For more information on custom groups, see Organizing values by groups and set.
In this recipe, you have two ticket groups, Support Group 1, and Support Group 2. Using an attribute group, you'll configure a group named Support Group 1 and 2 that contains all member of both ticket groups.
To create custom groups from your Zendesk Support groups
- In Query Builder, using the Tickets dataset, open the Calculations menu (
).
- Select the Group option underneath Attributes.
- Select the Ticket group attribute from the Computed from drop-down list. The Ticket group attribute contains your different Zendesk Support groups.
- Select Support Group 1, and then click +.
- Select Support Group 2, and then click the right arrow.
- Click the group name to rename it Support Group 1 and 2.
- In the Attribute name box, provide a name for the attribute. This is the name that you will choose when you add the attribute to a query. Enter Support group 1 and 2.
- Click Save.
After you finish creating your custom group attribute, add your metric to Metrics and your custom group attribute to one of the attribute locations (see Adding metrics and attributes to queries). This recipe adds COUNT(Tickets) to Metrics and the custom group attribute Support group 1 and 2 to Columns. In this case, we've shown the tickets in our grouped attribute against the total number of tickets in the entire support group.
Adding more advanced interactivity
To make this query more interactive, you can add advanced decompose options, so viewers can dig in and take a look at underlying Ticket Group performance.
This section contains the following topics:
Setting your decompose path
In Explore, viewers can use the Decompose interaction to slice specific data points by other attributes from your dataset. You can specify which attributes viewers can decompose on by applying settings in Chart configuration > Decompose type. This recipe uses one of the available options called Decompose path.
Decompose path enables your users to start at the top and drill all the way down to the most granular level of detail. When looking at tickets by your custom group attribute you created above, you could set Ticket group as well as Assignee as your decompose path to view the number of assignees in the different customer support group teams.
Decomposing your results
After you’ve saved your Decompose path, you can go ahead and decompose your data. To use decompose, click any of your columns or other data points visualizations for your chart type, then select Decompose.
This is one example of the many ways that advanced grouping and decompose options can help streamline your reporting. See Organizing values by groups and set and Interacting with queriesfor more information on using these features.
3 Comments
Hi there,
Is it possible to get the recipe for creating the recipe for the last chart? That would be much appreciated!
Best,
S.
Hi Stephanie,
Yes! Here's how you can create this chart in your workspace:
Metrics: COUNT(Tickets)
Columns: Ticket Group
Filters: Ticket Group (and just select the few groups that you'd like to keep an eye on)
Let me know if this helps!
- Andrew
Yes! Thanks, Andrew
Best,
S.
Please sign in to leave a comment.