 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