In this Explore recipe, you'll learn how to create an Explore report that will report on the number of tickets your agents are being assigned each day.
What you'll need
Skill level: Easy
- Zendesk Explore Professional or Enterprise
- Time Required: 15 minutes
- Zendesk Explore Professional Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
Creating the report
To create the report
- In Explore, click the reports (
) icon.
- In the Reports library, click New report.
- On the Select a dataset page, click Support > Support - Updates history, then click Start report. The report builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, choose Tickets > Tickets assigned, then click Apply.
- In the Columns panel, click Add.
- From the list of attributes, choose Assignee > Assignee name, then click Apply.
- In the Rows panel, click Add.
- From the list of attributes, choose Time - Ticket last assigned > Ticket assigned - Date, then click Apply.
- Under Filters, click Add.
- From the list of attributes, choose Time - Ticket last assigned > Ticket assigned - Date, then click Apply.
- 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 report is now complete. The screenshot below shows an example of the results.
5 Comments
Hi,
Will this include the tickets that were reassigned?
We have tickets that we reassigns to another agent when the assignee is on leave or on week off, we want to make sure that is being counted as well.
Hi Jane,
The recipe will include all ticket assignments, including reassignments. So any reassigned tickets will be captured by the query accordingly.
Warm Regards,
Eric
Eric G. Gao | Technical Support Architect | Zendesk
Hello.thank you for your quick support. What i would like to see is all tickets turned open on daily basis and not only the remaining open tickets at the end of the day.
Is that possible? and by open i mean:
I would try something like the following in the ticket updates dataset. The update - date would be the day you are looking at and the update ticket status would be set to open.
Best regards,
Thank you Alex. Really helpful !
Please sign in to leave a comment.