LOD function in tableau

LOD Function

Level Of Detail expressions (LOD) allows us to calculate values at data source level and visualization level in tableau application tool. This gives us more control over the level of granularity we want to calculate.

Types of LOD

1. FIXED
2. INCLUDE
3. EXCLUDE

• Fixed :
  
  It compute a value using the specified dimensions, without reference to the dimensions in the view.
  ex: {FIXED [Region] : SUM([Sales])}

• Include:
  
  Calculating values using specified dimensions other than whatever dimensions are in the view
  ex: { INCLUDE [Customer Name] : SUM([Sales]) }

• Exclude:
  
  It declare dimensions to omit from the view level of detail.
  ex: {EXCLUDE [Order Date (Month / Year)] : AVG({FIXED [Order Date (Month / Year)] : SUM([Sales])})}