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

Sorry what do you mean by this?

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]

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

Ah yeah thank you

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @joshmorris 

I doubt you can create a report on this assessment and perform calculations there, as per your screenshot — it doesn’t seem possible.

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

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