This recipe shows you how to report on the median first reply time in minutes for tickets solved each day of the previous week.
What you'll need
Skill level: Easy
Time Required: 10 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Giving agents access to Explore)
- Ticket data in Zendesk Support
How to create the report in Explore
- In 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.
- In the Metrics panel, click Add.
- From the list of metrics, choose Duration between events - Calendar hours (min) > First reply time (min), then click Apply.
Tip: If you want to see first reply time in business hours only, select the Duration between events - Business hours (min) > First reply time - Business hours (min) metric instead.
- In the Columns panel, click Add.
- From the list of attributes, choose Time - Ticket solved > Ticket solved - Date, then click Apply.
- Click the attribute you just added, then click Edit date ranges.
- On the Date range page, select Last week, then click Apply.
- Click the Visualization type menu (
) and select Column.
Tip: This report looks at the date the ticket was solved, but you can use any other date event.
73 comments
Permanently deleted user
Can someone tell me, why is the calculation is different result when I put "assignee" in the row?
0
Alex Zheng
By moving assignee to row you are changing the calculation slightly. When it is in the filters section it is finding the total average first reply time however once it is added to the rows section it is now getting the average first reply time of each assignee and then getting the average of those averages.
1
Brandon (729)
Alex Zheng -
You get a gold star for this - I was scratching my brain for an answer to this for most of the day.
Cheers,
Brandon
0
Daniel Cox
Hi All,
Can anyone help me split out the First Reply Time results in more detail?
The default results appear to be: "no reply", 0-1 hours, 1-8 hours, 8-24 hours and then >24 hours.
I would like the reply to match our SLAs (first response within 72 hours) a little closer - So show additional time frames? I.e. 1-8, 8-24, 24-48, 48-72 and >72 (for example).
I read various articles and played around with calculations - I couldn't work it out.
Anyone?
0
Noly Maron Unson
Hi Daniel,
You can use the formula below to create a Standard calculated attribute
Hope this helps.
1
Keti
Hi all!
I'm wondering if we have a similar metric for the talk dataset or if there's a formula we can use to achieve it?
I see there is the call wait time metric, but this includes the whole routing in queue between agents. What I'm looking for is a way to isolate the segment specifically for Agent X.
Example of the report:
Metrics:
Count Calls
Call Wait time (sec)
Rows:
Call Agent
When we see a value of "X" for Agent A in the Call Wait Time (seconds) metric, it appears to include the entire routing process between agents, including those who did not answer the call.
Is it possible to obtain only the time it took just for Agent “A” ?
0
Daniel Cox
Hi Noly Maron Unson, thank you for this. We will run some tests to see if we can get this working.
Can the same also be done for the First resolution time?
0
Permanently deleted user
can we count FRT on Reopen Chat?
how the formula to make that?
0
Himanshu Baghel
Hi Team,
I am new to Zendesk Explore and I am trying to create a FRT SLA report where I want to show all the chats responded within 1 min should show achieved% and after 1 min should show breached%.
Can someone help me on this?
Thanks in Advance
0
Gabriel Manlapig
Hi Himanshu,
You can create a report under the Chat: Engagement dataset and created a standard calculated attribute for this Chat SLA timing report.
For reference, please see the sample formula below:
In this example, I use less than or equal to 5 minutes, but feel free to adjust depending on your preferred timing in your case
<= 1
.And the result will show as:
In order to see the Achieved% and Breached%, you need to adjust the report, remove the attribute Ticket ID, and replace the metric from SUM (Chat first reply time) to COUNT (Chats).
After this, you just need to use the Result path calculation under Calculation manipulation and select the pattern % of total on columns.
And the result will show as:
And the report will show you an 80% achieve and a 20% breach rate for the Chat SLA. These articles may also be noteworthy to you and is found below:
0
Kris Parker
I'm trying to create a report that shows the average time per assignee for first assignment until first reply
I will neither confirm nor deny that I have fought with Explore for most of the day to attempt to get this created with several different paths all with no success (although I did have the opportunity to see a few different variations of Explore errors).
Has anyone performed this query before and have a snazzy way of reporting on it?
0
Quang Nguyen
Hello Team,
I'm trying to create a report that shows the average waiting time of our users for the previous week, including both tickets that have received a first reply and the unassigned tickets still waiting for one.
I was initially just using MED(First reply time (hrs)) but the result wasn't including the waiting time for unassigned tickets created by users that were still waiting for the first reply.
I'm looking for guidance on how to include in a report, the waiting time for unassigned tickets without a first reply, and if possible, how to combine this with the median first reply time for answered tickets.
Thank you.
0
Eric Brower
Hi,
Looking for help creating a custom metric to understand how long it takes us to call back when a voicemail is left. Our tickets that ended in voicemail are using the Ticket Tag “voicemail” so I'm using that as a filter.
How can I calculate the # of minutes between the time that the call started, and when the first outbound call on the ticket was initiated?
0