Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to create Incident Backlog Growth PA report monthwise

sugand
Tera Contributor

Hi,

I need to create a PA report on Incident Backlog Growth month-wise for last 6 months. Formula Indicator is Number of New incidents - Number of resolved incidents. Somehow it's not showing up the data for all 6 months, just for 1 month I'm able to view.

It has 2 contributing indicators setting frequency as monthly and 2 indicator source as well.

 

Please help to achieve this.

sugand_0-1692691286578.png

 

Thanks,

Sugan

5 REPLIES 5

AndersBGS
Tera Patron
Tera Patron

Hi @sugand ,

 

It could be the PA job or the conditions in either the indicator source or automated indicator. Can you please share a snip of these? Then it will be much easier to help you.

 

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

 

best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

sugand
Tera Contributor

Hi Anders,

Below is the screenshot of job and indicator source for your ref.

 

sugand_0-1692697963403.png

 

sugand_1-1692698026653.pngsugand_2-1692698101433.pngsugand_3-1692698152905.png

 

Thanks,

Sugan

Hi @sugand ,

 

Is it correct that you only have run the daily data collection and not the historical collection? 

According to your first screenshot you only have 4 incidents in growth but if we look at the historical collection, it should collect on monthly basis for the last 6 months?

 

Furthermore, why do you use a condition "opened/resolved last 6 months"? Wouldn't you rather 6 the data change on monthly basis? 

 

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

 

best regards

Anders

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

sugand
Tera Contributor

Hi Anders,

I found one other thing that 'Historical Job' collected with warnings, what should be done to rectify those warnings. Please suggest.

 

Thanks.