How to report backlog

Learn SN
Tera Contributor

 

Hi Experts,

 

I have reports which tell me how many incidents were created and resolved each month but I also want to have what is the backlog for each  month , i.e. on given month how many incidents / requests  were in active state. 

 

Is it possible to do that? Can someone help me with it ?

 

Thanks!

Uma

6 REPLIES 6

asifnoor
Kilo Patron

You can get this by default using incident.list and adding filters such as active=true and created in the given month.

Are you looking at any pictorial representation of this data?

Check like below

1. Create New Report

2. select table incident and on right side add filter and click active = true. click Next

3. Select type of graph as Line in Time Series section  and click Next

4. Then select Group By as state and then select trend by created, per=month and aggregation = count and click Next

5. Then you will see count of active incidents by month.

Aaron Munoz
Tera Guru

It's easy to tell if an incident was created or resolved in a given month because those date/time fields don't change over time, but the Active field does change over time.

This use case is what Performance Analytics was meant for. It runs a job every day that queries a facts table, like incident, and stores the result of which incidents had active=true on each day.

Peformance Analytics is a licensed product though. The alternative would be to look at the logs of each incident to see when the Active field changed its value.

Adam Stout
ServiceNow Employee
ServiceNow Employee

I would try out Complimentary Performance Analytics for Incident Management.  You can only keep 180 days worth of scores, but it should get you what you want you are looking for Out of the Box.