Forum Discussion
Getting The Average For the Top 5 Results
I have a small football stats spreadsheet where I'm trying to calculate certain measures per team, dimensions (goals, corners etc), match etc. Each entry into the MatchStats table will have an entry ...
Not sure I understand the difference between [MatchID] and [DimID] but you shared very few information + we don't know what's the purpose of the 'Dimensions' table and if there's any relationship set between 'MatchStats' & 'Dimensions'. All this to say that what's attached might be partially/totally wrong (pic. cropped)
EDIT
- Added measure [Count_Last5]
- Revised measure [Avg_Last5_Above2]
Otherwise if < 5 Matches in 'MatchStats' [Avg_Last5_Above2] will be wrong
Also, I'm showing how much of a newbie I am, I didn't even know you could use the created measures as you've done in your sample.
Without being able to attach the file, let me give you some more info
The Dimensions table (bad name I know) is a list of different type of attributes:
1. Goals
2. Offsides
3. Corners
There are 2 measure tables, (again bad names)
Matches (MatchID, HomeTeamID, AwayTeamID, MatchDate)
MatchStats (as per sample above)
Let me review your samples, already they look much better than mine!!
Without being able to attach the file, let me give you some more info
The Dimensions table (bad name I know) is a list of different type of attributes:
1. Goals
2. Offsides
3. Corners
There are 2 measure tables, (again bad names)
Matches (MatchID, HomeTeamID, AwayTeamID, MatchDate)
MatchStats (as per sample above)
Let me review your samples, already they look much better than mine!!