How to show monthly backlog of Problems in ServiceNow Reporting

[JatinderP]

Hi All,

I want to show a bar graph showing trend of last 6 months or 1 year to show at the end of month how many problem tickets were open in total.

[OlaN]

Hi,

This sounds like something that would require Performance Analytics.

Reports can only show you current data, i.e whats stored in your instance.

If you need to save historic data, like how many problems were open at a specific point in time, you will need to set up a metric for that, which requires Performance Analytics.

[JatinderP]

Hi @OlaN , do you know steps to using Performance Analytics. Thanks J

[OlaN]

Performance Analytics is a Paid plugin, so first you'll need to see if this is within your license.

Then I can recommend looking at the learning course on the Developer site.

https://developer.servicenow.com/dev.do#!/learn/courses/tokyo/app_store_learnv2_reportanalytics_toky...

[AndersBGS]

Hi @JatinderP ,

You can utilize the normal report module, if you "just" want to see how many that has been opened on month basis. 

1. Create a report based on the problem table:

2. Choose a time series vizulization:

3. choose trend by = Opened and per = month

4. Create the filter for how long time you would like the visualization to show:

result:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders