It’s a bit complex:
1 tab will have team stats for the selected team, date range, and conditions; functionally this is one row
1 tab will have stats for each player for the selected team, date range, and conditions; I’m using an inline list to let the user go between the players, but these have 1 row per player; functionally this could be 1 row each on separate sheets, but I have it as ~9 rows on 1 sheet
I also want to add 1 tab to show the 5 most played lineups for the selected team and date range, with stats for each lineup; I am planning for this to be 5 rows.
Ideally, the home page asks the user to select a team from a choice list, and select start and end date from a date picker. Either on the home page or on the stats pages, the user can select individual players to be in or out, and some other game conditions, as choice lists.
My goal is for the stats (embedded in tables) to update as the user selects new conditions. It’s been challenging to figure out how to best set this up; I had used a QUERY function but am testing out other formulas to sum up some key data, and then using Math columns in the data editor to calculate the stats.
My main goal is to let my subscribers explore some of this data on their own, so if there’s a different structure I’d be open to that. The trickiest part is making sure one user’s inputs don’t affect the view for others.