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/