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.
9 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 !
Hello,
Will this include the tickets that were reassigned to a group as well if I am filtering with a specific group?
The Tickets assigned metric will only count events where a ticket is assigned to a particular agent. If the ticket is assigned to the group and a specific agent, then yes, the metric should include the ticket. But, if you are referring to tickets that were assigned to a group (without a particular agent assignee), then those won't be counted in the report above. You may need to look at the Group reassignments metric or create a custom calculation that will count tickets where a value was set for either assignee_id or group_id.
Hope this helps. Thanks Abdelrahman!
How can I remove the reassigns from the ticket assigned per day? I want to see only newly created ticket assignments to see how many new tickets were picked by the agents.
You may use result metric calculation to subtract the value of the native metric Assignee reassignments from the Tickets assigned metric.
Or, you may create a custom metric that only counts assignments of previously unassigned tickets. Example:
Please sign in to leave a comment.