Looking for help on the best way to set this up:
My company is running a 16-week run/bike challenge and we are using airtable to track everybody’s totals. This is the information we’re going to track:
- Participant Name
- Office Location
- Run Distance (by week)
- Run Time (by week)
- Bike Distance (by week)
- Bike Time (by week)
- Total Run/Bike Distance (by week)
- Total Run/Bike Time (by week)
- Overall Run/Bike Distance (running total of each week)
- Overall Run/Bike Time(running total of each week)
The eventual views we want participants to see is a weekly leaderboard (grouped by Week 1, Week 2, etc.) and an overall leaderboard (showing the running totals).
So, what’s the best way to organize this so that i can track the weekly data and then feed that into the overall running totals?