Ricerche recenti

Nessuna ricerca recente

Getting the average resolution time from a custom attribute

Con risposta
image avatar

Joanna Kime

Data ultimo post: 17 nov 2021

I have a requirement where I need to create a report that will show me the average time to resolve 90% of incident tickets after a checkbox has been checked. 

The event timeline would read = ticket is created > ticket is marked as incident > checkbox is checked > ticket is resolved. 

I have already created an attribute that is able to calculate the resolution time between the checkbox being checked and the ticket being resolved. However, I am unsure how to progress to get an average resolution time from this attribute. 

Any help would be greatly appreciated!

Attribute code to get the checkbox timestamp

IF ([Changes - Field name]="Root Cause Analysis ")
AND
(([Changes - Previous value]="0") OR
([Changes - Previous value]=NULL))
AND
([Changes - New value]="1")
THEN
[Update - Timestamp]
ENDIF

Attribute code to get the resolution time in days

ROUND(DATE_DIFF([Ticket solved - Timestamp],[Root Cause Analysis Time],"nb_of_days"))

1

1

1 commento

Data
    image avatar

    Gab Guinto

    Zendesk Customer Care

    Hi Joanna,
     
    Looks like you were able to build the custom metric needed to calculate the time from when the checkbox is selected until resolution. This should already give you the date_diff between the two timestamps for each ticket. If you are looking to report on the average value across all tickets, then you just need to use the aggregator Average (AVG) with this metric. Note that if you slice your data by Ticket ID, you'll just get the individual values for each ticket; the query should not have the attribute Ticket ID under Rows/Columns for the report to display actual AVG values. 

    -1

    Accedi per aggiungere un commento.

    Non hai trovato quello che cerchi?

    Nuovo post