Recent searches
No recent searches
Show average reply time
Answered
Posted Mar 01, 2019
Hey!
We're looking for a possibility to display average individual reply time.
That means the average time between the ticket is set to open and resolved.
Requester wait time metric is a combination of all replies in a lifetime of a ticket - but we're looking into seeing the time for each individual touch. I hope it makes sense.
At this point, it is clear that we have to use custom calculation - I would really appreciate If you could help me to figure the formula out or direct me towards a resource that may help.
0
13
13 comments
Patrick Bosmans
Hello Maksims,
I see that you have a ticket with Support at this time. I am going to followup with some specific detail there.
0
Zenjob
Hi there,
are there any updates on this issue?
I am also looking into reporting the average reply time.
Thanks in advance!
0
Carlos Navarro
Hi, Martin. We do have a metric called Requester wait time (min), which measures the number of minutes a ticket spends in the New, Open, and On-hold statuses, which is generally when you're customers are waiting for a reply from agents. After you add it to your query, you can click on the metric and select AVG as the aggregator of this metric to get the average and click Apply (see Changing the metric aggregator).
If you're trying to measure how much time agents actually spend working on tickets and composing replies, the Time Tracking app metrics would probably be more suitable. Have you checked those out?
Thanks.
0
Zenjob
Thank you Carlos!
0
Maksims Svjastins
Hey, Martin!
The solution provided by Carlos will actually show you the combined time that the ticket spends in these statuses - the more interactions there are in the ticket - the longer will be the metric.
We were looking for an average reply time of every email customer sends us. It's not something Zendesk can do out of the box - but we were able to create a custom metric that is close to what we wanted (it does have some limitations).
Here's how it looks:
IF ([Changes - Field name] = "status"
AND ([Changes - Previous value]="open" OR [Changes - Previous value]="new")
AND [Comment present] = TRUE
AND [Comment public] = TRUE
AND [Updater role] != "End-user")
THEN Value(Field changes time (min))
ENDIF
It calculates the time between the ticket status updates - from the customer reply to agent reply with a ticket status update. (From Open to Ticket statu change + Public comment)
1
Zenjob
Thank you Maksims.
That is really helpful! And I see your point of looking only at the time between answers. That's what I initially looked for.
Cheers.
1
Ninja Raj (SG-CS RTFM)
Its show error . Kindly anyone help > need to find totally avg reply time ( base on group).
0
Taylor Bowser
Hi Ninja Raj,
Thanks for reaching out! It looks like the attributes are not being recognized in the formula editor. These attributes are only available in the Support: Ticket Updates dataset. Can you confirm if you are using this dataset to create your report?
Best,
0
Michelle Mattern
@... super helpful - thank you for sharing your custom metric! I am looking for something similar - the average reply time for any request. I want to capture the initial response time AND the response time of any future injuries on the same ticket. I assume that in my scenario, I want to remove this line from your metric:
AND ([Changes - Previous value]="open" OR [Changes - Previous value]="new")
Does that sound correct?
@... thank you for your reply, too - I was previously trying to use the 'tickets' dataset but this worked when I switched over to the 'ticket updates' dataset.
1
Melanie Scarth
Following here:
Can someone help me to create this in explorer ?
This is what I currently have : But would like the average reply time
1
Michelle Mattern
@... you need to swap out the "first reply time" metric for a custom metric as described by Maksims and Ninja Raj earlier in this thread.
0
Si Ying Tan
Thank you for sharing the recipe.
I tried it but noticed it seems to measure the time based on calendar hours (not business hours)? The figures seem a lot larger than we're expecting.
Similarly, we're also looking to measure the average time taken for our customers to receive our responses, in business hours context.
0
Devan La Spisa
Hello @...,
You should be able to use the metric Requester wait time business hours to accomplish this and resolve the extra data you are running into.
Best regards.
0