Is there any way to get a Median in a Report?

Alon Grod
Tera Expert

I need to create a report that shows the median answers response for a survey for a specific assignment group.
When I choose aggregation, i dont have an option 'median'. How can I achieve that? 

Screenshot 2023-09-28 at 8.34.27.png

 

Screenshot 2023-09-28 at 8.34.40.png

 

 

Screenshot 2023-09-28 at 8.35.03.png

4 REPLIES 4

AndersBGS
Tera Patron
Tera Patron

Hi @Alon Grod ,

 

if you have performance analytics available in your instance, then this can easily be utilized to do the calculation.

 

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 @Alon Grod 

 

If my answer has helped with your question, please mark my answer as accepted solution.

 

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/

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Alon Grod 

 

Greetings!!

 

In standard reporting this not available , may be you can check 

 

AtulyaG_0-1695894238890.png

 

 

As my friend @AndersBGS  said, if you have PA installed, it is easy to do.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Alon Grod 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************