FIXED LOD expression in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does a FIXED LOD expression do in Tableau?

It calculates a value at the level of detail you specify, ignoring the view's filters and dimensions.

beginner

Write a simple FIXED LOD expression to calculate total sales per region.

{FIXED [Region] : SUM([Sales])} calculates total sales for each region regardless of other filters.

intermediate

How does FIXED differ from INCLUDE and EXCLUDE LOD expressions?

FIXED calculates at a set level ignoring view filters except context filters; INCLUDE and EXCLUDE adjust level based on view context and respect all filters.

intermediate

Can FIXED LOD expressions be affected by context filters?

Yes, FIXED LOD expressions respect context filters but ignore other filters.

beginner

Why use FIXED LOD expressions in dashboards?

To get consistent calculations at a specific level, like total sales per customer, regardless of how users slice data.

What does the FIXED keyword in Tableau LOD expressions do?

A Calculates values at a specified level ignoring view filters

B Includes extra dimensions in calculation

C Excludes dimensions from calculation

D Filters data before calculation

FIXED calculates values at the level you specify, ignoring most filters except context filters.

Which of these is a correct FIXED LOD expression to sum sales by category?

A SUM([Sales])

B {INCLUDE [Category] : SUM([Sales])}

C {EXCLUDE [Category] : SUM([Sales])}

D {FIXED [Category] : SUM([Sales])}

The FIXED expression fixes calculation at the Category level.

Do FIXED LOD expressions consider filters that are not context filters?

A No, only context filters affect FIXED LOD

B Only dimension filters affect FIXED LOD

C No filters affect FIXED LOD

D Yes, all filters affect FIXED LOD

FIXED LOD expressions ignore all filters except context filters.

If you want to calculate sales per customer ignoring other dimensions, which LOD expression should you use?

A {INCLUDE [Customer] : SUM([Sales])}

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

C {EXCLUDE [Customer] : SUM([Sales])}

D SUM([Sales])

FIXED fixes calculation at the Customer level regardless of other dimensions.

Which statement is true about FIXED LOD expressions?

A They always ignore all filters including context filters

B They calculate values dynamically based on view filters

C They calculate values at a fixed level and respect context filters

D They only work with aggregated data

FIXED LOD expressions calculate at a fixed level and respect context filters.

Explain how FIXED LOD expressions work and when you would use them in Tableau.

Think about fixing calculation level regardless of how user filters or slices data.

Describe the difference between FIXED, INCLUDE, and EXCLUDE LOD expressions with examples.

Focus on how each changes the level of detail for calculation.

Practice

1. What does a FIXED LOD expression do in Tableau?

easy

A. Calculates a value at a specific dimension level, ignoring other filters

B. Filters data dynamically based on user selection

C. Aggregates data only after all filters are applied

D. Creates a new calculated field without aggregation

Solution

1. Step 1: Understand FIXED LOD purpose

   FIXED LOD calculates values at a fixed dimension level regardless of other filters.

2. Step 2: Compare with other options

   Dynamic filtering based on user selection and aggregating data after all filters do not describe FIXED LOD. Creating a new calculated field without aggregation is unrelated.

3. Final Answer:

   Calculates a value at a specific dimension level, ignoring other filters -> Option A

4. Quick Check:

   FIXED LOD = fixed level calculation [OK]

Hint: FIXED means fixed level, ignoring filters [OK]

Common Mistakes:

• Confusing FIXED with INCLUDE or EXCLUDE LOD
• Thinking FIXED respects all filters
• Assuming FIXED creates dynamic filters

2. Which of the following is the correct syntax for a FIXED LOD expression to calculate total sales by Region?

easy

A. SUM({FIXED [Region] [Sales]})

B. FIXED {SUM([Sales]) BY [Region]}

C. {FIXED [Region]: SUM([Sales])}

D. {INCLUDE [Region]: SUM([Sales])}

Solution

1. Step 1: Recall correct FIXED LOD syntax

   The correct syntax is {FIXED [Dimension]: AGG([Measure])}.

2. Step 2: Check each option

   {FIXED [Region]: SUM([Sales])} matches syntax exactly. The other options have invalid syntax like misplaced braces, missing colons, or use INCLUDE instead of FIXED.

3. Final Answer:

   {FIXED [Region]: SUM([Sales])} -> Option C

4. Quick Check:

   Correct FIXED syntax = {FIXED [Region]: SUM([Sales])} [OK]

Hint: FIXED syntax: {FIXED [Dimension]: AGG([Measure])} [OK]

Common Mistakes:

• Using INCLUDE instead of FIXED
• Misplacing braces or colons
• Omitting aggregation function

3. Given the data below, what is the result of {FIXED [Category]: SUM([Sales])} when placed on a view filtered to only show 'Furniture' products?

Data:
- Category: Furniture, Office Supplies
- Sales: Furniture = 1000, Office Supplies = 500

Options:

medium

A. 0

B. 1500

C. 500

D. 1000

Solution

1. Step 1: Understand FIXED LOD computes before viz filters

   {FIXED [Category]: SUM([Sales])} computes SUM([Sales]) partitioned by [Category] using full dataset before the Category filter.

2. Step 2: Calculate for Furniture

   Furniture total sales = 1000. Filter shows only Furniture (assuming Category on view), displaying 1000.

3. Final Answer:

   1000 -> Option D

4. Quick Check:

   FIXED [Category] = per-Category total for shown Category [OK]

Hint: FIXED [dim]: AGG = per-dim total before filter [OK]

Common Mistakes:

• Thinking FIXED ignores partition dim (picking grand total 1500)
• Confusing with {FIXED : SUM([Sales])} grand total
• Confusing FIXED with INCLUDE

4. Identify the error in this FIXED LOD expression:

{FIXED [Region] SUM([Profit])}

medium

A. Missing colon ':' after [Region]

B. SUM cannot be used inside FIXED

C. Braces {} are not allowed in FIXED expressions

D. Region should be inside quotes

Solution

1. Step 1: Check FIXED LOD syntax

   Correct syntax requires a colon ':' after the dimension list inside braces.

2. Step 2: Identify missing colon

   The expression misses ':' after [Region], causing syntax error.

3. Final Answer:

   Missing colon ':' after [Region] -> Option A

4. Quick Check:

   Colon required after dimension list [OK]

Hint: Always put ':' after dimensions in FIXED [OK]

Common Mistakes:

• Omitting colon ':' after dimension
• Misusing aggregation functions
• Incorrect brace usage

5. You want to create a dashboard showing each Product's sales as a percentage of total sales across all Regions, ignoring any Region filters applied. Which FIXED LOD expression correctly calculates total sales ignoring Region filters?

hard

A. {INCLUDE [Region]: SUM([Sales])}

B. {FIXED : SUM([Sales])}

C. {FIXED [Region]: SUM([Sales])}

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

Solution

1. Step 1: Understand requirement to ignore Region filters

   To ignore Region filters, FIXED expression should not include Region dimension.

2. Step 2: Analyze each option

   {FIXED : SUM([Sales])} fixes calculation at overall level (no dimension), ignoring Region filters. {FIXED [Region]: SUM([Sales])} fixes by Region, so respects Region. Options A and D use INCLUDE and EXCLUDE, not ignoring Region filters fully.

3. Final Answer:

   {FIXED : SUM([Sales])} -> Option B

4. Quick Check:

   FIXED without dimension ignores all filters [OK]

Hint: FIXED with no dimension ignores all filters [OK]

Common Mistakes:

• Including Region in FIXED when wanting to ignore it
• Using INCLUDE or EXCLUDE instead of FIXED
• Assuming EXCLUDE ignores filters fully