How to report backlog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2019 11:34 PM
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
- Labels:
-
Performance Analytics

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2019 11:45 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2019 12:18 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2019 07:39 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2019 09:45 AM
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.