In this recipe, you'll learn how to create a query that displays the number of tickets that were unsolved in your account at the end of each month.
This article contains the following topics:
What you'll need
Skill level: Easy
- Time required: 15 minutes
- Zendesk Explore Professional
- Editor or Admin permissions (see Adding users to Explore)
- Ticket data in Zendesk Support
Creating the query
To create the query
- In Zendesk Explore, click the query () icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Support > Backlog history > Support: Backlog history, then click New query. Query Builder opens.
In the Metrics panel, click Add.
- From the list of metrics, choose Backlog tickets (unsolved) > Tickets, then click Apply.
- In the Rows panel, click Add.
- From the list of attributes, choose Time - Backlog recorded > Backlog recorded - Year and Time - Backlog end of period > End of month, then click Apply.
Optional: Applying a date filter
- In the Filters panel, click Add.
- From the list of attributes, choose Time - Backlog recorded > Backlog recorded - Date, then click Apply.
- Click the filter you just added, click Edit date ranges, and then configure your required dates.