Tableau Calculated Fields and LODs Questions and Answers

Question 1

An analyst wants to create a bar chart showing the total sales for each Sub-Category. They also want to display a reference line showing the average sales for the corresponding product Category for comparison. The view contains [Category] and [Sub-Category] on the Rows shelf. Which calculation will correctly compute the average sales at the Category level, regardless of the Sub-Category detail in the view?

Accepted Answer

{FIXED [Category] : AVG([Sales])}

Answer

A FIXED LOD expression computes a value using specified dimensions without reference to other dimensions in the view. `{FIXED [Category] : AVG([Sales])}` calculates the average sales for each Category and will return the same value for all sub-categories within that category, making it ideal for a reference line. EXCLUDE would be relative to the view, INCLUDE would make the calculation more granular, and WINDOW_AVG is a table calculation that operates on the values currently in the visualization.

Question 2

You are creating a view that shows Sales by [Region] and [State]. You need to calculate the percentage of total sales that each state contributed to its region. Which of the following LOD expressions would be most appropriate for the denominator in your percentage calculation (i.e., the total sales for the region)?

Accepted Answer

{EXCLUDE [State] : SUM([Sales])}

Answer

The `EXCLUDE` LOD expression is ideal for 'percent of total' scenarios where you need to compute an aggregation at a less granular level than the view. Since the view is at the [State] level, `{EXCLUDE [State] : SUM([Sales])}` will remove the [State] dimension from the calculation's context, effectively summing sales at the [Region] level, which is the correct denominator.

Question 3

Which of the following best describes a key difference between a FIXED Level of Detail expression and an INCLUDE/EXCLUDE LOD expression in relation to filters?

Accepted Answer

FIXED LOD expressions are computed before regular dimension filters are applied, whereas INCLUDE/EXCLUDE expressions are computed after.

Answer

According to Tableau's Order of Operations, FIXED LOD expressions are computed before dimension filters. This means that unless the filter is added to context, a standard dimension filter will not affect the result of a FIXED LOD. In contrast, INCLUDE and EXCLUDE LOD expressions are calculated after dimension filters, so their results will be affected by them.

Question 4

A calculated field uses the `ATTR()` function on a dimension, like `ATTR([Customer Name])`. In a visualization, this field returns an asterisk (*). What does this signify?

Accepted Answer

There is more than one distinct [Customer Name] associated with the data for that specific mark in the view.

Answer

The ATTR() function tests if a field has a single, unique value within the context of the mark. If MIN(dimension) = MAX(dimension), it returns that value. If there are multiple different values, it returns an asterisk (*) to indicate this.

Question 5

You need to create a calculated field to show the sales for the most recent year in the dataset. Which of the following calculations correctly isolates the sales for the latest year?

Accepted Answer

IF YEAR([Order Date]) = {MAX(YEAR([Order Date]))} THEN [Sales] END

Answer

This calculation uses a table-scoped FIXED LOD `{MAX(YEAR([Order Date]))}` to find the single latest year in the entire dataset. It then compares each row's Order Date year to this fixed maximum year. This is a row-level calculation that correctly flags sales from only the most recent year. The other options are incorrect because `MAX(YEAR([Order Date]))` would be an aggregate and cause an error, `YEAR(TODAY())` assumes the data is current, and the `WINDOW_MAX` option is an unnecessarily complex table calculation.

Tableau Practice Test

Tableau Practice Test

Tableau Calculated Fields and LODs Questions and Answers