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.

Pie chart is not working with Performance Analytics Indicators/Performance Analytics Jobs

Rakshanda Kunte
Tera Contributor

Hi,

 

I have created new Historical Job which ran from Sep 2023 till Mar 01, 2024. (Last 6 Months)

RakshandaKunte_0-1709287023175.png

 

 

It has collected the data for last 6 months. 

 

But when I select chart type = Pie Chart, it only shows data for last 1 month:

RakshandaKunte_1-1709287023071.png

 

 

However, if I select chart type = column, then it shows the correct data collected for last 6 months.

If you see report here, for above report it has fetched only 1 month data.

RakshandaKunte_2-1709287023043.png

 

 

 

Can you help to fix this?

 

 

Thanks.

4 REPLIES 4

AndersBGS
Tera Patron
Tera Patron

Hi @Rakshanda Kunte ,

 

You just need to group as shown below:

AndersBGS_0-1709288999762.png

This will give you below result:

AndersBGS_1-1709289024411.png

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/

Hi @AndersBGS,

 

I am using Performance analytics Indicator here. When I use Pie chart it only shows data for 1 month. 

But, last 6 months' data is already collected by newly created Historical Job. 

 

If I use Column Chart, it works fine. Only giving error while when I use Pie/Donut/Semidonut charts.

 

Any Idea?

(All Screenshots are attached above). 

Let me know if anything required. 

 

 

Thanks.

Hi @Rakshanda Kunte ,

 

It doesn't matter how much data (which timespan) you have collected, but it's about your widget configuration. 

 

AndersBGS_0-1709295933459.png

As you see in above example, here is chosen "by year sum". 

 

If you would like to see the change_request created within the last 6 months by type, I would recommend to utilize change_request as table instead of an automated indicator, and make the filter for last 6 months. There is no possibility when chose an automated indicator to select last 6 months.

 

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/

Gm @AndersBGS ,

 

Thanks for your inputs.

 

However, we can achieve the same by applying date range.

 

RakshandaKunte_0-1709535579715.png

 

 

But, in my case even after applying date range, it does not work for pie chart.

 

Thanks.