Now, I would like to set up a Repeating Group that shows :
songC / Total score 9
songA / Total score 8
songB / Total score 5
…
And the list should be ranked by highest score.
First setup the search with any constraints needed. You then add group by, and set the grouping to be the song field, and then use an aggregation to add up all the scores for each song. The sorting is added to the end of the grouping, just use descending on sum of Score.
After several people have scored the songs, I have a database of Scores. Is it possible to make a new database that stores the total score per song? This way the rankings would load more quickly on the webpages, I think.