Tableau Level of Detail (LOD) Expressions Explained with Examples

Level of Detail (LOD) expressions allow you to compute values at the data source level and the visualization level without having to bring dimensions directly into the viz grid.

1. FIXED LOD

Computes the expression using only the specified dimensions, ignoring dimensions present in the viz.

```tableau

{ FIXED [Customer ID] : SUM([Sales]) }

```

2. INCLUDE LOD

Computes the expression using the specified dimensions in addition to whatever dimensions are in the viz.

```tableau

{ INCLUDE [State] : AVG([Sales]) }

```

3. EXCLUDE LOD

Computes the expression subtracting the specified dimensions from the viz granularity.

```tableau

{ EXCLUDE [Region] : SUM([Sales]) }

```