Skip to main content

Rollup of Team totals

  • March 20, 2021
  • 1 reply
  • 3 views
B
Forum|alt.badge.img+11

I have a simple table (See below). I want to create a Leaderboard that shows each team and their total score across several quizzes in order from Highest to lowest total.

I am not sure if my initial setup is the best.

I know I can group by the Team and it will give me the total score but there is no way (that I know of) to sort by the Total Score.

  1. I don’t have experience using a Rollup and can’t figure out how to set up the second table to gather the needed info.
  2. Does anyone know of a good app that will take my AirTable result and make a pretty leaderboard that I can embed on a website and automatically update as new data comes into AirTable,

R
Forum|alt.badge.img+4
  • Rose_K
  • Inspiring
  • March 26, 2021

Hello @Brite_Admin!

Based on the information in your post I created a 3 table base setup that I think may work for your needs.

The first table tracks the number of Quizzes (I made them separate quizzes but you could make another table to track questions to associate to each quiz depending on what workflow would work best for you):

The second table tracks Teams and each of their scores(I’ll expand on the rollup field further down):

The third table is a joins table that tracks each Team’s score for each Quiz. So each time a team completes a quiz you could create a new record using this table to track the team, quiz, and their score for that quiz :

(As an aside the main “Unique Name” field is an identifier for that record, and is a formula tracking the team and Quiz with a Autonumber field)

With those three tables in place you can now use the Rollup field on the Team’s table to find out a team’s average score:

Then, depending on how you’d like to visualize the leaderboard, you could use the Chart App to visualize the score for each team:

I hope this helps, but please let me know if I can expand on any of the above!

Reply


Most helpful members this week

Terms & Conditions