I'm looking to create report(s) that calculates the total number of days since an update has been made to individual tickets. One report will be generic ie Time since ANY update was done.
Id like to be able also have report calculating the amt of time since the assignee update the ticket with a comment and last time the requester updated the ticket.
For the first report (any update) I tried creating a custom metric
DATE_DIFF(TODAY(),[Ticket updated - Timestamp],"nb_of_days") and used SUM. The values returned were not accurate:
Oddly enough if I used AVG with the metric (instead of SUM) I received accurate values. Which doesn't make sense