Backlog trend of open incidents.

Mark Curtis
Kilo Contributor

‎02-14-2019 02:36 AM

hi all, I am trying to create a graph that shows cumulative backlog of incidents. it is easy in MS Excel but need to create it in Servicenow..please see attached example and any help much appreciated. Thanks Mark

Labels:
Preview file
46 KB
  • 6,917 Views
10 REPLIES 10

Slawek_Radziewi
Kilo Sage

‎02-14-2019 02:52 AM

It should be rather simple using Performance Analytics. 

There you just define indicator for data you need. Opened vs Resolved and show it in Weekly time scope. 

Check below example for new.

find_real_file.png

 

find_real_file.png

Preview file
60 KB
Preview file
25 KB

Michelle Replog
Tera Contributor
In response to Slawek_Radziewi

‎12-05-2022 01:12 PM

I would think the "by week sum" would significantly increase the true backlog, since it should just be a snapshot of a point in time.  Wouldn't you just want the value either at the beginning or end of week to see the trend of how many are open daily?

0 Helpfuls

Mark Curtis
Kilo Contributor

‎02-14-2019 03:09 AM

Thanks for the above. I am new to Servicenow so a little unsure how to implement the above. Could you give a little bit more info on how to create this (child like steps 🙂 Thanks

0 Helpfuls