MIP Logo

How Include/Fixed/Exclude Tableau LOD expressions are calculated

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

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

Share this post