Show average reply time

Hello Maksims,

I see that you have a ticket with Support at this time. I am going to followup with some specific detail there.

Hi there, 

are there any updates on this issue?

I am also looking into reporting the average reply time.

Thanks in advance!

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.

Thank you Carlos!

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) 

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.

Its show error . Kindly anyone help > need to find totally avg reply time ( base on group).

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, 

@Maksims Svjastins 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?

@Taylor Bowser 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.

Following here: 

Can someone help me to create this in explorer ? 

This is what I currently have : But would like the average reply time

@Melanie Scarth 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.

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.

Hello @Si Ying Tan,

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.