Explore recipe: Unsolved tickets by group

In this Explore recipe, you'll learn how to create a query to show the number of unsolved tickets by group in a bar graph.

What you'll need

Skill level: Easy

Time Required: 10 minutes

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

Creating the query

To create the query

1. In Zendesk Explore, click the query () icon.
2. In the Queries library, click New query.
3. On the Choose a dataset page, click Support > Tickets > Support: Tickets, then click New query. Query builder opens.
4. In the Metrics panel, click Add.
5. From the list of metrics, choose Unsolved tickets > Unsolved tickets, then click Apply.
6. In the Columns panel, click Add.
7. From the list of attributes, choose Ticket > Ticket group, then click Apply.
8. From the visualization type () menu, click Bar.
9. From the chart configuration (), menu click Displayed values and change Show value to Show.
   
   The query is complete. Here is an example of how the query will look.