Google Sheets Longterm Dashboard for Athletes | Part 5 | Team Avg & Score

In this video we finish off the KPI charts by adding the team average, and score values and then creating the actual graphs. This will allow you to turn on and off the series as well as display the averages.
► Support DSMStrength HERE: www.buymeacoff...
►Purchase this dashboard HERE: tinyurl.com/DS...
SUBSCRIBE TO DSMSTRENGTH: bit.ly/3xRrNH7
[Books I Love] Support the Channel
►Periodization: amzn.to/2mOiBDA
►Strength Coach Guide to Excel amzn.to/2xAEZ4p
►Strength Coach Playbook: amzn.to/2mY9crI
►Principles and Practice of Resistance Training: amzn.to/2mM1Jf6
►High Performance Training for Sport: amzn.to/2mqWb74
[Connect with Me]
►See all Strength Coach Tutorials: bit.ly/2mLU5Bf
►Check our website: www.dsmstrength...
[Social Media]
►Instagram: / dsmstrength
►Twitter: / dsmstrength
►Facebook Page: / dsmstrength

[@sarahmiller2182]

How can we change the average score to be for that specific date? Right now it shows the average for all tests over time, can we update the average to show how the team average changes over time? Thank you so much for these tutorials!!

[@DSMStrength]

=average(filter(data, data = specific date)) something like that would work

[@jordanwelsh3085]

How can we change the average score to a average for their age? Just so we can see what they look like compared to others in their year group