Ricerche recenti

Nessuna ricerca recente

Average Ticket Age Backlog Timeline (Not by ticket create)

Con risposta
image avatar

Mani Berenji

Data ultimo post: 25 set 2019

I'm attempting to report on the impact of ticket age month over month. Similar to the backlog evolution report, I need to understand the average age of tickets that were in the backlog month over month.

 

Insights only lets me plot the data by ticket create date which isn't helpful to me.

0

4

4 commenti

Data
    image avatar

    Chris H

    Hello Mani,

     

    You can do this in Explore using a custom metric. I have created an example I will share the screenshots of it here with you. Here is the metric I created to get that age of tickets in days.

    Then I created the report like this.

    I hope this helps!

     

    Best,

    Chris H

    0

    image avatar

    Ranganath B S

    Hi Chris,

    Even I had the same question, when I tried the above query I got syntax error, 
    and im expecting differences in hours. not days. Need your help

    Thanks
    Ranga

    0

    image avatar

    ZZ Graeme Carmichael

    Community Moderator

    Ranga

    We can make this a little simpler:

    IF [Ticket status - Unsorted]="Solved" or [Ticket status - Unsorted]="Closed"
    THEN DATE_DIFF([Ticket solved - Timestamp],[Ticket created - Timestamp],"nb_of_days")
    ELSE
    DATE_DIFF( NOW() ,[Ticket created - Timestamp],"nb_of_days")
    ENDIF

    To age in hours rather than days, change the "nb_of_days" parameter to "nb_of_hours":

    IF [Ticket status - Unsorted]="Solved" or [Ticket status - Unsorted]="Closed"
    THEN DATE_DIFF([Ticket solved - Timestamp],[Ticket created - Timestamp],"nb_of_hours")
    ELSE
    DATE_DIFF( NOW() ,[Ticket created - Timestamp],"nb_of_hours")
    ENDIF

     

    1

    image avatar

    Ranganath B S

    Hey Graeme,

    Thanks for your help. it worked.

    0

    Accedi per aggiungere un commento.

    Non hai trovato quello che cerchi?

    Nuovo post