Need help with group by and average on 2 column table

[sarahjbc]

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...

[TheTimeSavingCo]

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 

[sarahjbc]

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!