Mastering Tableau 2018.1, Second Edition 9.5: Using Filters and LODs

The video tutorial explains the order of operations in Tableau, focusing on how filters and Level of Detail (LOD) expressions interact. It covers the priority of fixed, include, and exclude LOD expressions, and demonstrates how different filters, such as dimension and context filters, affect LOD expressions. The tutorial also previews the next section, which will cover spatial analysis and mapping in Tableau.

What is the main focus of the order of operations in Tableau?

• To manage user access levels

• To establish the sequence of applying filters and expressions

• To prioritize different types of calculations

• To determine the sequence of data loading

How are fixed level of detail expressions calculated?

• Based on all available dimensions

• Without reference to any specific dimension

• Based on specific dimensions passed inside the calculation

• Using a random selection of dimensions

Why do fixed level of detail expressions have high priority?

• They are dependent on user input

• They are calculated last

• They are the default setting in Tableau

• They are independent of dimension filters

Which type of filter has the lowest priority in Tableau's order of operations?

• Measure filter

• Fixed level of detail expression

• Dimension filter

• Context filter

What is the effect of adding a dimension filter on fixed level of detail expressions?

• It deletes the fixed level of detail expressions

• It has no effect on the fixed level of detail values

• It changes the fixed level of detail values

• It duplicates the fixed level of detail values

What happens when a context filter is added in Tableau?

• It deletes all existing filters

• It changes the order of operations, affecting level of detail expressions

• It lowers the priority of all other filters

• It has no effect on the data

What is the role of context filters in Tableau?

• To change the order of operations and affect level of detail expressions

• To override the default settings

• To create new data fields

• To provide a visual representation of data