Calculate average

joshmorris
Tera Guru

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

joshmorris_0-1753881491242.png

 

1 ACCEPTED SOLUTION

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.

 

 

DrAtulGLNG_0-1753888882198.png

 

 

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

8 REPLIES 8

Mark Manders
Mega Patron

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

No, in the screenshot it is a list report

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

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]

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