Percentage of Incidents Meeting SLA by Month

adidosc
Giga Contributor

Hello All!

 

I am trying to help write a report for my manager that looks like the chart below.   The idea is to provide a trend chart, by month, of SLAs that have achieved SLA.   Using the provided reports in ServiceNow, I haven't quite been able to achieve the same style report.   Any thoughts?

 

SLA_Incidents_by_Month.PNG

14 REPLIES 14

adidosc
Giga Contributor

Calling any master report builders!!  


We do something almost identical to this in our Crossfuze incident and request turnkey products.   How about something like the screenshot below?



Crossfuze_-_Development.jpg


Thanks for the info Mark!   It is closer than we had before, but I am now wondering if the exact format of the example graph is even able to be recreated in ServiceNow.   I haven't been able to find a way or an example of adding the percentages on the bars, trend line, or to aggregate by percentage instead of count/average/sum.


Without setting up a completely custom chart (which is a royal pain to build and manage) that is about as close as you'll get.   You do get the percentages by hovering over the bar sections and you can also see them in the details of the report if you're showing details.   The only thing I see that you're missing is the trend line after that.   Seems like an extremely close fit.