I had a group of students fill out a form in which they gave star ratings to a group of submissions. So the result is a table in which each record/row includes one student’s ratings. The column headers are the submitters’ names.
What I want to do is calculate the average rating for each submission and then sort the results by that number (highest- to lowest-rated submissions). In my table, I can get the average to show in the summary bar. But then I don’t know how to create a table or view that allows me to sort those averages of each column.
I’ve read over a bunch of other posts that talk about rollups and formulas for calculating averages, but I have not been able to figure out how to make it work in my case. Wondering if I need to have two linked tables somehow.
Thanks for any suggestions.