Tableau · Quick Reference

Lesson 12 — LOD Expressions Cheat Sheet

Tableau

In one line: Every visualization in Tableau has a view level of detail — the combination of dimensions currently on Rows, Columns, or the Detail shelf. All measures are automatically aggrega...

Key Ideas

1What Are LOD Expressions & Why They Exist. Every visualization in Tableau has a view level of detail — the combination of dimensions currently on Rows, Columns, or the Detail shelf. All measures are automatical...

2FIXED LOD — The Most Commonly Used. A FIXED LOD computes at exactly the dimensions you specify, ignoring the current view dimensions entirely. It does not care what is or isn't on the view — it always lo...

3INCLUDE LOD — Adding Granularity. An INCLUDE LOD computes at the view's current level of detail plus the dimensions you specify. It makes the aggregation more granular than the view. The results are th...

4EXCLUDE LOD — Removing Granularity. An EXCLUDE LOD computes at the view's level of detail minus the dimensions you specify. It makes the aggregation less granular than the view — rolling up over the excl...

5LOD vs Table Calculations — Which to Use?. Both LOD Expressions and Table Calculations can compute aggregations beyond what the view directly shows, but they work in fundamentally different ways. Choosing the w...