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.

performance analytics to get total case for last 3 months

charan_1
Tera Contributor

I need to create the total no.of hr case for last 3 months in performance. Can anyone help me with this how it is possible to solve it.

1 ACCEPTED SOLUTION

Hi @charan_1 ,

 

Chose count instead of sum. You don't need to sum any data, thus you just want a count of how many records that has been created.

 

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/

View solution in original post

7 REPLIES 7

Hi @charan_1 ,

 

Just create the indicator source as below:

 

AndersBGS_0-1693827933732.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 

After creating indicator source when i start creating automated indicator under aggregate when i select the dropdown sum it is asking to choose the field can you help me with this if i select active returns only active records i need full records.

screenshot.png

Hi @charan_1 ,

 

Chose count instead of sum. You don't need to sum any data, thus you just want a count of how many records that has been created.

 

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/