Help Creating Metric of Solved the same day
I want to create % of tickets resolved on day 1 2 and 3
I can get the numerators but not the denominator. Any help would be greatly appreciated.
Same Day
SELECT # Solved Tickets WHERE (Date (Ticket Created)= Date (Ticket Solved))
+1 day
SELECT # Solved Tickets WHERE (Date (Ticket Created)+1= Date (Ticket Solved))
-
Comentário oficial
Hi Steven!
A reopened ticket would be counted in this metric once its solved again (with its last "Solved Date" as the data being considered)
-
Hi Sean,
Are you trying to get the % of tickets solved on days 1 OR 2 OR 3 divided by all of your solved tickets? That would make your denominator the # Solved Tickets metric, if that's the case, I think.
-
Hi Sean!
As Kristin noted above, the denominator is likely going to be # Solved Tickets. Drop a line in here if that's not working and let us know what you're specifically looking to do with this metric!
-
Thanks all this is working. Appreciate the help from the community
-
Great this has really helped me, just wondering does anyone know would this factor out if a ticket was reopened?
Por favor, entrar para comentar.
5 Comentários