Explore recipe: Ticket assigns per day

In this Explore recipe, you'll learn how to create an Explore query that will report on the number of tickets your agents are being assigned each day.

What you'll need

Skill level: Easy

• Time Required: 15 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 > Ticket updates > Support: Ticket updates, then click New query. Query Builder opens.
4. In the Metrics panel, click Add.
5. From the list of metrics, choose Tickets > Tickets assigned, then click Apply. 
6. In the Columns panel, click Add.
7. From the list of attributes, choose Assignee > Assignee name, then click Apply.
8. In the Rows panel, click Add.
9. From the list of attributes, choose Time - Ticket last assigned > Ticket assigned - Date, then click Apply.
10. Under Filters, click Add.
11. From the list of attributes, choose Time - Ticket last assigned > Ticket assigned - Date, then click Apply.
12. Click the filter,  click Edit date ranges, then click Last week.
    

If you want to set a different date range, see Editing dates and date ranges.

The query is now complete. The screenshot below shows an example of the results.