INCLUDE LOD expression in Tableau - Deep Dive

Overview - INCLUDE LOD expression

What is it?

INCLUDE LOD expression is a way in Tableau to calculate values at a more detailed level than the view's current level of detail. It lets you add dimensions temporarily to your calculation without changing the whole visualization. This helps you get more precise numbers, like subtotals or averages, based on extra details.

Why it matters

Without INCLUDE LOD expressions, you would struggle to get accurate calculations that consider extra details without changing your whole chart. This means you might get wrong totals or averages, making decisions based on incomplete data. INCLUDE LOD solves this by letting you add detail only where needed, keeping your visuals clear and your numbers correct.

Where it fits

Before learning INCLUDE LOD, you should understand basic Tableau calculations and how dimensions affect aggregation. After mastering INCLUDE LOD, you can explore EXCLUDE and FIXED LOD expressions for more control over data granularity.

Mental Model

Core Idea

INCLUDE LOD expression lets you add extra detail to a calculation temporarily, so you can get precise numbers without changing the whole view.

Think of it like...

Imagine you are baking cookies and the recipe says to add chocolate chips per cookie, but you want to know how many chips are in each batch. INCLUDE LOD is like counting chips per cookie first, then adding them up for the batch, even if your recipe only shows the batch size.

View Level of Detail
┌───────────────┐
│ Dimension A   │
│ Dimension B   │
└───────────────┘

INCLUDE adds:
┌───────────────┐
│ Dimension A   │
│ Dimension B   │
│ Dimension C   │  ← temporarily included
└───────────────┘

Calculation happens at this finer level,
then aggregates back to view level.

Build-Up - 7 Steps

1

Foundation

Understanding Tableau Level of Detail

Concept: Learn what level of detail means in Tableau and how it affects calculations.

In Tableau, level of detail (LOD) refers to the granularity of data used in calculations. For example, if your view shows sales by region, the level of detail is 'region'. Calculations aggregate data at this level by default.

Result

You understand that Tableau aggregates data based on the dimensions in your view.

Knowing how Tableau groups data helps you see why sometimes calculations don’t match expectations when extra detail is needed.

2

Foundation

Basic Calculations and Aggregations

Concept: Learn how to create simple calculated fields and how aggregation works.

A calculated field can sum sales or count customers. Aggregation means combining many rows into one number, like total sales per region. By default, Tableau aggregates at the view’s level of detail.

Result

You can create basic sums, averages, and counts that reflect the current view.

Understanding aggregation is key to knowing why you sometimes need to adjust the level of detail.

3

Intermediate

Introducing INCLUDE LOD Syntax

🤔Before reading on: do you think INCLUDE changes the view’s dimensions permanently or only inside the calculation? Commit to your answer.

Concept: Learn the syntax and purpose of INCLUDE LOD expressions in Tableau.

INCLUDE LOD syntax looks like this: { INCLUDE [Dimension] : AGGREGATION([Measure]) }. It tells Tableau to calculate the measure including the extra dimension(s) inside the braces, even if those dimensions are not in the view.

Result

You can write calculations that consider more detail than the current view shows.

Knowing that INCLUDE only affects the calculation, not the whole view, lets you get precise numbers without cluttering your visualization.

4

Intermediate

Using INCLUDE to Calculate Subtotals

🤔Before reading on: do you think INCLUDE can help calculate subtotals without adding extra columns to the view? Commit to your answer.

Concept: Apply INCLUDE LOD to calculate subtotals or averages at a finer level than the view.

For example, if your view shows sales by region, but you want average sales per customer within each region, you can write: { INCLUDE [Customer ID] : AVG([Sales]) }. This calculates average sales per customer, then aggregates to region level.

Result

You get subtotals or averages that reflect more detailed data without changing the view layout.

Understanding this use of INCLUDE helps you create richer insights while keeping your dashboard clean.

5

Intermediate

Combining INCLUDE with Filters

🤔Before reading on: do you think INCLUDE LOD respects filters applied to the view or ignores them? Commit to your answer.

Concept: Learn how INCLUDE LOD expressions interact with filters in Tableau.

INCLUDE LOD calculations respect dimension filters but ignore non-context filters unless those filters are set as context. This means your calculation might include data you expect to be filtered out unless you use context filters.

Result

You understand how to control which data INCLUDE LOD uses by managing filters properly.

Knowing this prevents confusion when your INCLUDE calculations show unexpected results due to filter behavior.

6

Advanced

Performance Considerations with INCLUDE LOD

🤔Before reading on: do you think using many INCLUDE LOD expressions slows down Tableau dashboards? Commit to your answer.

Concept: Understand how INCLUDE LOD expressions affect Tableau performance and best practices to optimize.

INCLUDE LOD expressions can increase query complexity because Tableau must compute data at a finer level temporarily. Using many or complex INCLUDE expressions may slow dashboards, especially on large datasets. Best practice is to limit INCLUDE use to necessary cases and combine with data extracts or context filters.

Result

You can write efficient INCLUDE LOD calculations that balance detail and speed.

Knowing performance tradeoffs helps you design dashboards that are both accurate and responsive.

7

Expert

Advanced INCLUDE LOD Patterns and Pitfalls

🤔Before reading on: do you think INCLUDE LOD can cause double counting if misused? Commit to your answer.

Concept: Explore complex scenarios where INCLUDE LOD expressions can cause unexpected results and how to avoid them.

When combining INCLUDE LOD with other LOD types or aggregations, you can accidentally double count or misalign data. For example, including a dimension that overlaps with the view’s dimensions can inflate sums. Experts carefully design calculations and test results to avoid these traps.

Result

You can confidently use INCLUDE LOD in complex reports without errors.

Understanding these subtle pitfalls prevents costly mistakes in business reports and builds trust in your data.

Under the Hood

INCLUDE LOD expressions tell Tableau’s query engine to temporarily add specified dimensions to the aggregation level inside the calculation. Tableau generates SQL queries that group data by these extra dimensions, compute the aggregation, then roll up results to the view’s level. This happens behind the scenes, so the visualization stays unchanged while calculations are more detailed.

Why designed this way?

Tableau designed INCLUDE LOD to give users flexible control over calculation granularity without forcing them to change the view layout. This balances ease of use with powerful analytics. Alternatives like FIXED LOD fix the level regardless of view, but INCLUDE lets you add detail dynamically, which is often more intuitive.

View Level of Detail
┌───────────────┐
│ Dimension A   │
│ Dimension B   │
└───────────────┘

INCLUDE LOD Calculation
┌───────────────┐
│ Dimension A   │
│ Dimension B   │
│ Dimension C   │  ← temporarily added
└───────────────┘

Aggregation Steps:
1. Group data by A, B, C
2. Calculate aggregation (e.g., SUM)
3. Roll up results to A, B for view display

Myth Busters - 3 Common Misconceptions

Quick: Does INCLUDE LOD permanently add dimensions to the view? Commit yes or no.

Common Belief: INCLUDE LOD adds dimensions permanently to the visualization.

Reality: INCLUDE LOD only adds dimensions inside the calculation temporarily; the view’s dimensions stay the same.

Why it matters: Believing this causes confusion when users expect the view to change or try to add dimensions manually, leading to cluttered dashboards.

Quick: Does INCLUDE LOD ignore all filters by default? Commit yes or no.

Common Belief: INCLUDE LOD calculations ignore all filters applied to the view.

Reality: INCLUDE LOD respects dimension filters but ignores non-context filters unless set as context filters.

Why it matters: Misunderstanding this leads to unexpected data in calculations, causing incorrect business decisions.

Quick: Can INCLUDE LOD cause double counting if misused? Commit yes or no.

Common Belief: INCLUDE LOD calculations always produce correct sums without risk of double counting.

Reality: If INCLUDE adds dimensions overlapping with view dimensions or combined improperly, it can cause double counting.

Why it matters: Ignoring this can produce inflated metrics, misleading stakeholders and damaging trust.

Expert Zone

1

INCLUDE LOD expressions can be combined with table calculations for layered insights, but order of operations matters deeply.

2

Using INCLUDE with context filters changes which data is included, so setting filters as context is a subtle but powerful control.

3

INCLUDE LOD can interact unexpectedly with data blending or joins, requiring careful testing in multi-source dashboards.

When NOT to use

Avoid INCLUDE LOD when you need fixed granularity regardless of view, where FIXED LOD is better. Also, for very large datasets with many INCLUDE expressions, consider pre-aggregating data or using extracts to improve performance.

Production Patterns

Professionals use INCLUDE LOD to calculate customer-level metrics inside region-level views, compute rolling averages with extra date detail, and create dynamic subtotals without cluttering dashboards. They combine INCLUDE with context filters to control data scope precisely.

Connections

SQL GROUP BY

INCLUDE LOD expressions translate to SQL GROUP BY clauses with extra columns.

Understanding SQL grouping helps grasp how Tableau computes INCLUDE LOD behind the scenes, improving debugging and optimization skills.

Pivot Tables in Spreadsheets

Both pivot tables and INCLUDE LOD let you summarize data at different levels of detail.

Knowing pivot tables helps beginners understand the idea of changing aggregation levels dynamically, which is what INCLUDE LOD does in Tableau.

Photography Depth of Field

INCLUDE LOD is like adjusting camera focus to see more detail temporarily without changing the whole scene.

This cross-domain link shows how focusing on extra detail selectively can reveal hidden insights without overwhelming the whole picture.

Common Pitfalls

#1 Double counting when including overlapping dimensions

Wrong approach:

{ INCLUDE [Region] : SUM([Sales]) } used in a view already showing Region

Correct approach:

Use FIXED LOD or remove overlapping dimensions from INCLUDE to avoid double counting

Root cause:

Misunderstanding that INCLUDE adds detail inside calculation but can overlap with view dimensions causing sums to multiply

#2 Unexpected results due to filter ignoring

Wrong approach:

Applying non-context filters expecting INCLUDE LOD to respect them fully

Correct approach:

Set important filters as context filters to ensure INCLUDE LOD respects them

Root cause:

Not knowing Tableau’s filter order of operations and how INCLUDE LOD interacts with filters

#3 Performance slowdown from excessive INCLUDE LOD use

Wrong approach:

Writing many complex INCLUDE LOD expressions on large datasets without optimization

Correct approach:

Limit INCLUDE use, use extracts, and apply context filters to improve performance

Root cause:

Ignoring query complexity and resource demands of INCLUDE LOD calculations

Key Takeaways

INCLUDE LOD expressions let you add extra detail inside calculations without changing the view layout.

They help get accurate subtotals and averages by temporarily increasing granularity.

INCLUDE respects dimension filters but requires context filters for full filtering control.

Misusing INCLUDE can cause double counting or performance issues, so careful design is essential.

Mastering INCLUDE LOD unlocks powerful, flexible analytics in Tableau dashboards.