Calculate average

joshmorris · ‎07-30-2025

Hi, I was wondering if it is possible to automatically calculate an average of the actual values and show it at the bottom?

Dr Atul G- LNG · ‎07-30-2025

Hi @joshmorris

For example, I created a report on the rm_story table to view the average story points.
I used Report Type = Single Score and selected "Average" as the function.

In your case, you can do the same:
Create a report on the relevant Assessment table, and use the actual values field to calculate the average.

*************************************************************************************************************
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]

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

View solution in original post

Mark Manders · ‎07-30-2025

Is this a list? You can right click on the header and select 'list calculations'.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

joshmorris · ‎07-30-2025

No, in the screenshot it is a list report

joshmorris · ‎07-30-2025

As you say, it does get me what I want in a list view but I need it on a dashboard

Dr Atul G- LNG · ‎07-30-2025

Create a report for single scores, and then you can calculate the average from that.

*************************************************************************************************************
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]

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