Calculating the average star rating of a column and sorting the results

Topic Labels: Formulas
979 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

0 Replies 0