Report same day resolution rate

mattdouhan
Kilo Contributor

How can I use standard report tools to report same day resolution rate?

For example total number of tickets opened today is 100

10 of the are resolved today so the same day resolution would be 10%

I can only find how to tell the number of same day resolved tickets by using Opened AND resolved in my filter but I cannot figure out how to put that towards my total number of tickets opened that day

Any help greatly appreciated

11 REPLIES 11

Michael Fry1
Kilo Patron

How about something like this where opened is same as Resolve but makes sure to check Show Other


qq.jpg


That works great as long as that is the only filter criteria, but as soon as I add another one for example I want to see the same day resolution for today, I only get true and it does not show other any longer, Can you try and add a second filter to yours and see what happens on your side? I added "opened on today" with AND clause and then it does not show "other" anymore I only get the true ones


You can't add another condition or it breaks the query. Opened - is same - Day - as - Resolved is your 2 conditions in 1.


ok so this only works for incidents since we started using servicenow?



Not for a specific time period?



Any way to do what I want?