Explore recipe: Number of tickets submitted by your users

This Explore recipe shows you how to find how many tickets each of your users submit.

What you'll need

Skill level: Easy

Time Required: 5 minutes

• Zendesk Explore Professional
• Editor or Admin permissions (see Adding users to Explore)
• Ticket data in Zendesk Support
  
  

How to create the report in Explore

Use the following steps to create this report in Explore.

1. In 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. Next, add your metrics, the things you want to measure; in this case, the number of tickets created. In the Metrics panel, click Add.
5. From the list of metrics, choose Tickets > Tickets, then click Apply.
6. In the Rows panel, click Add.
7. From the list of attributes, choose Requester/user > Requester name, then click Apply.
8. Optionally, from the list of attributes, you may want to choose an attribute under Time - ticket created or Time - ticket solved, which will allow you to slice this data by week or month, for example.