Suite | Professional, Enterprise, or Enterprise Plus |
Support with | Explore Professional or Enterprise |
For this reason, you'll also see any tickets that your agents assigned to themselves and solved in the same action showing as 0.
What you'll need
Skill level: Moderate
Time Required: 20 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
Creating the report
To create the report
- In Zendesk Explore, click the reports (
) icon.
- In the Reports library, click New report.
-
On the Select a dataset page, click Support > Support - Tickets, then click Start report. The report builder opens.
- Now, create a standard calculated metric to show the time between first assignment to first resolution. Click Calculations (
), then click Standard calculated metric.
- On the Standard calculated metric page, add a name for the metric like First assignment to first resolution time.
- Enter or paste the formula below into the Formula field.
(VALUE(First resolution time (min))/60/24) - (DATE_DIFF([Ticket first assigned - Timestamp], [Ticket created - Timestamp], "nb_of_days"))
Tip: If you're working in a language other than English, read this article to help you enter Explore formulas in your language. - Click Save.
- In the Metrics panel, click Add.
- From the list of metrics, choose Calculated metrics > First assignment to first resolution time (the metric you just created), then click Apply.
- Ensure the metric aggregator for First assignment to first resolution time is set to AVG (see Choosing metric aggregators).
- In the Rows panel, click Add.
- From the list of attributes, choose Assignee > Assignee name, then click Apply.
- Click the Assignee name attribute you just added and exclude NULL from the results.
- From the Chart configuration (
) menu, click Display format.
-
On the Display format page, change AVG(First assignment to first resolution time) to Custom. Then make the following changes:
- Decimal place: 1
- Suffix: days
You could also add a date filter to the report by using the information in Editing dates and date ranges.
The report is now complete. See the screenshot below as an example.
17 comments
Alyson
Hello all,
May I know the way to crerate the report for 24/7 (24 hours FRT and 7 days resolution) across the markets? (We are having different business hour)? How can we adjusts the calculatics part in the metric and should I choose “Support-update history" when creating the report?
Thanks!
0
Gabriel
A formula disponivel no artigo esta apresentando erro.
0
Dave Dyson
In answer to your question about first assignment and triggers, Time - Ticket first assigned is the time when the ticket was first assigned to an agent. So in your example with two triggers, it would be the time the second trigger assigned the ticket to an agent.
0
CJ Johnson
1900360390924 I see your image says "Last assignment to resolution time". I found that this metric doesn't really work for my tickets. The metric doesn’t handle multiple resolutions or reassignments correctly. It returns negative days/hours if a ticket reopens and resolves.
It also counts a ticket changing from assigned to unassigned, as a re-assignment. So if you had an agent solve a ticket, then un-assign it from themselves 5 hours later, it returns -5 hours for Last Assignment to Resolution.
0
mfg
Is first assignment inclusive of system triggers or only through agent reassignments? I'd like to measure our reassignment rate and the time it takes to reassign.
If there are two cascading triggers that make assignments (ie one to a group, then a second to an individual), would these be counted as two?
An alternative approach, assuming there was only one reassignment, it seems like [resolution time] - [last assignment to resolution] would work, but to limit it to only tickets where there was one agent reassignment I need to know if the trigger assignments would count toward that total.
Except that the last assignment to resolution time seems to be giving me inaccurate data - why would there be so many 0.0 hr tickets?
0
CJ Johnson
Is there any way to get this returned as a timestamp instead?
0
Allen Lai | Head of CX at Otter.ai
1263082116169
I'd like to calculate this by business hours, but the First Assignment Time metric does not have a business hours option. Is there a way to create a custom standard calculated metric to achieve this?
Ideally, I'd like the formula to measure the true resolution time to be:
0
Dave Dyson
"Last assignment to resolution time (hrs)" would measure the time in hours from the last time the ticket was assigned to someone, to the time the ticket was resolved. This could happen if a ticket was escalated from one team to another, or one agent to another.
-1
Allen Lai | Head of CX at Otter.ai
How is this different from "Last assignment to resolution time (hrs)"?
0
Gab Guinto
The calculation is based on calendar hours. There's a business hours metric for resolution time, but the first assignment time in Explore is measured only in calendar hours, so I'm afraid there's currently no option to get an accurate calculation of first assignment to resolution in business hours. But, you can modify the formula above and reference the business hours metric for First resolution time, but just note that the value of First assignment time in the metric calculation won't take into account your business hours/schedule.
0
Sign in to leave a comment.