Mastering Tableau 2018.1, Second Edition 9.3: Working with Fixed, Include, Exclude Expressions

The video tutorial provides an in-depth look at Level of Detail (LOD) expressions in Tableau, focusing on three main functions: fixed, include, and exclude. The fixed function allows users to specify a particular level of detail, while the include function adds dimensions not present in the canvas. The exclude function removes specific levels of detail. The tutorial concludes with a brief introduction to nested LODs, setting the stage for more complex data visualizations.

What is the primary purpose of the 'Fixed' function in LOD expressions?

• To remove dimensions from the level of detail

• To calculate the average of a measure

• To add dimensions to the level of detail

• To set a specific level of detail for aggregation

Which function would you use if you want to override the default level of detail in a Tableau visualization?

• Aggregate

• Fixed

• Exclude

• Include

How does the 'Include' function affect the level of detail in a Tableau visualization?

• It fixes the level of detail to a specific dimension

• It removes dimensions from the level of detail

• It adds dimensions to the level of detail

• It calculates the sum of a measure

Which function would you use to calculate a measure at a more granular level than the current view?

• Aggregate

• Include

• Exclude

• Fixed

What is the effect of using the 'Exclude' function in LOD expressions?

• It removes dimensions from the level of detail

• It calculates the average of a measure

• It adds dimensions to the level of detail

• It fixes the level of detail to a specific dimension

Which LOD function would you use to aggregate data at a higher level than the current view?

• Include

• Exclude

• Fixed

• Aggregate

In the context of LOD expressions, what does the 'Exclude' function allow you to do?

• Fix the level of detail to a specific dimension

• Calculate the sum of a measure

• Remove dimensions from the level of detail

• Add dimensions to the level of detail