I made a quick project for your review.
https://x.thunkable.com/projectPage/6187ef95280f1a0010dac7e7
The idea is to create a group. I created it by looping through the records and filling a list. Ideally you want to create the grouping inside Airtable.
See this example
I’m here making a column as a group which adds two fields together within Airtable by doing this
Now that I do not have access to your table to add a column, I did the grouping in Thunkable. Once the grouping is done, I then filled the list with group names from the list without repeating the names. (I made the names from the 3 columns with “||” as separator.
When you click on the item in the list, I loop through the main list to count the entries and total the scores and in the end I display the average.
Hope this helps.
