Ricerche recenti

Nessuna ricerca recente

Calculating time between status updates

Con risposta
image avatar

Britta Felzmann

Data ultimo post: 05 gen 2021

I am trying to calculate the time between status updates.

For example: How long to tickets usually take to go from ticket status "Open" to "Pending"?

I am having difficulties here because there is no time stamp for when a ticket receives the status open, there is only information about how long a ticket stays in a status. 

I have tried it with the datasets "Tickets" as well as "Ticket updates" but both of them don't seem to contain the right metrics. I have also tried to calculate the right numbers but that doesn't work because of the missing time stamps. 

Is there some other way to retrieve those metrics? 

Thanks in advance for the help!

 

0

2

2 commenti

Data
    image avatar

    Chandra Robrock

    Most Helpful - 2021Community Moderator

    Hi @...! If you're looking for the average time it takes for a ticket to move from the Open to Pending status, I'd recommend using the Ticket Updates dataset.

    For Metrics, you can select AVG(Open status (min)) and then filter based on the Update Ticket Status is Pending. That should allow you to see how long it takes for a ticket to move from the Open to the Pending ticket status on average.

    1

    image avatar

    Britta Felzmann

    Hi @..., thank you so much for the help. It works great!

    0

    Accedi per aggiungere un commento.

    Non hai trovato quello che cerchi?

    Nuovo post