最近搜索

没有最近搜索

Average Ticket Age Backlog Timeline (Not by ticket create)

已回答
image avatar

Mani Berenji

已于 2019年9月25日 发布

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 条评论

日期
    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

    请先登录再写评论。

    找不到所需的内容？

    新建帖子