Skip to main content

Need help with group by and average on 2 column table

  • October 26, 2024
  • 2 replies
  • 24 views
S
Forum|alt.badge.img+3

I have a base with a table: Scores that has 2 fields in it. Field 1: TeamName, Field 2: QuizScore

What I would like to accomplish is to generate a leaderboard where the Average QuizScore per TeamName is displayed. There may be several TeamName records with differing QuizScores.  I do not want to show the detail records in the Interface. Just the summary records. I'm not sure the best way to do this. I managed to link to table: AvgScores, where I calculate the average. But, I cannot figure out how to do an animation, where when a new record is added to Scores, how to I update AvgScores. 

The TeamName is created in another application, so, I can control how it is spelled/formatted. So, I can match a field in AvgScores. But, I can't figure out how to do that either. I'm an old SQL hack...

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Assuming your data is set up like this:

Then you could try an automation that pastes the team name into the linked field to the Teams table:

Link to base 

Adam, Airtable Consultant - thetimesaving.company
S
Forum|alt.badge.img+3
  • sarahjbc
  • Author
  • New Participant
  • 1 reply
  • November 4, 2024

Assuming your data is set up like this:

Then you could try an automation that pastes the team name into the linked field to the Teams table:

Link to base 


Thank you so much! I had it working correctly up to the automation! Your help was vital in getting me where I needed to go...and that was on a few days of vacation! I appreciate your help!


Terms & ConditionsAccessibility statement