Automatic Indicator for table with calculated scores

FredrikT
Tera Guru

I have a table with already calculated scores that I am trying to create automated indicators on but the historical job I have is not retuning the individual scores, but instead seems to be influenced by the aggregate attribute of the indicator.  table example:

 

measure name, period, scores

measure1, 10/1/2023, .80

measure2, 10/1/2023, .95

measure3, 10/1/2023, .70

measure1, 11/1/2023, .82

measure2, 11/1/2023, .94

measure3, 11/1/2023, .75

 

I am hoping someone point me to documentation where the automated indicator being created is not looking for a count, sum, average etc. but jut pulling the value from the score column for a given measure name.

 

Thank you!

3 REPLIES 3

AndersBGS
Tera Patron
Tera Patron

Hi @FredrikT 

 

I guess that you're talking about performance analytics? If yes, then you will not find the documentation, as an automated indicator always  looking for some mathematical aggregation:

AndersBGS_0-1701872169510.png

What is it that you would like to do with the scores already captured?

 

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 @FredrikT 

 

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/

FredrikT
Tera Guru

Yes, Thank you, I am looking to add PA widgets to a dashboard with these scores.  The reason I did not start with a manual indicator was that there are many measures where manual entry would be too tedious and instead the the source table could be refreshed monthly.  These two posts seem to support the possibility?

 

https://www.servicenow.com/community/platform-analytics-forum/manual-or-automated-indicators/m-p/126...

https://www.servicenow.com/community/platform-analytics-forum/import-indicator-score-data-from-excel...