Want to know what’s going on behind the scenes when using LOD fields? This guide will breakdown the differences between how include, fixed and exclude and how they are calculated
Calculated LOD fields:
{Include [Player] : AVG([Score])}
{Fixed [Player] : AVG([Score])}
{Exclude [Player] : AVG([Score])}
NO DIMENSION
NoLOD
When there is no dimension, noLOD will be calculated by averaging the entire score without considering the player.
Calculation: Average(5+6+2+7+10+11+12+6+9)
(5+6+2+7+10+11+12+6+9)/9 = 7.56
Include
Average the total score of each player and then average the averages.
Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)] = 7.75
[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75
Fixed
Calculated the same as Include
Exclude:
Ignores the Player column – hence, calculated same as noLOD
PLAYER
NoLOD
Average the total score of each player
A Calculation: Average(5+6+2+7+10) = 6.00
(5+6+2+7+10)/5 = 6.00
B Calculation: Average(11+12+6+9) = 9.00
(11+12+6+9)/4 = 9.00
Include
Average the total score of each player within each player and then average the averages
A Calculation: Average[Average(5+6+2+7+10)] = 6.00
[(5+6+2+7+10)/5]/1 = 6.00
B Calculation: Average[Average(11+12+6+9)]
[(11+12+6+9)/4]/1 = 9.50
Fixed
Average the total score of each player and then take the average of these averages (same calculation as Include in this case)
A Calculation: Average[Average(5+6+2+7+10)]
[(5+6+2+7+10)/5]/1 = 6.00
B Calculation: Average[Average(11+12+6+9)]
[(11+12+6+9)/4]/1 = 9.50
Exclude
Ignores the Player column – hence, finds the average of all scores
A Calculation: Average(5+6+2+7+10+11+12+6+9)
(5+6+2+7+10+11+12+6+9)/9 = 7.56
B Calculation: Same as A Calculation.
TEAM
NoLOD
Average the score for each team
AUS Calculation: Average(2+10+11+9)
(2+10+11+9)/4 = 8.00
GBR Calculation: Average(5+6+7+12+6)
(5+6+7+12+6)/5 = 7.20
Include
Average the total scores for each player within each team and then average the averages
AUS Calculation: Average[Average(2+10) + Average(11+9)]
[(2+10)/2 + (11+9)/2]/2 = 8.00
GBR Calculation: Average[Average(5+6+7) + Average(12+6)]
[(5+6+7)/3 + (12+6)/2]/2 = 7.50
Fixed
Average the total scores for each player (regardless of team) then take the average of this average for each player
AUS Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)]
[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75
GBR Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)]
[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75
Exclude:
Ignores the Player column – hence, calculated same as noLOD
YEAR
NoLoD
Average the scores for each year
2012 Calculation: Average(5+2+7)
(5+2+7)/3 = 4.67
2013 Calculation: Average(6+10+11+12+6+9)
(6+10+11+12+6+9)/6 = 9.00
Include
Average the total scores for each player within each year and then average the averages
2012 Calculation: Average(5+2+7)
(5+2+7)/3 = 4.67
2013 Calculation: Average(Average(6+10) + Average(11+12+6+9))
((6+10)/2 + (11+12+6+9)/4)/2 = 8.75
Fixed
Average the total scores for each player (regardless of year) then take the average of this average for each player
2012 Calculation: Average[Average(5+6+2+7+10)]
[(5+6+2+7+10)/5]/1 = 6.00
2013 Calculation: Average[Average(5+6+2+7+10)+ Average(11+12+6+9)]
[(5+6+2+7+10)/5 + (11+12+6+9)/2]/2 = 7.75
Exclude
Ignores the Player column – hence, calculated same as noLOD
