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

SUM({EXCLUDE [Sub-Category] : AVG([Sales])})

Answer

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

Answer

WINDOW_AVG(SUM([Sales]))

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

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

Answer

{FIXED : SUM([Sales])}

Answer

{FIXED [Region], [State] : SUM([Sales])}

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

INCLUDE/EXCLUDE LODs are calculated before dimension filters, while FIXED LODs are calculated after.

Answer

FIXED LODs ignore all filters, including Context Filters.

Answer

All LOD expressions are calculated after dimension filters in the Tableau Order of Operations.

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 [Customer Name] field contains a NULL value for the given mark.

Answer

The calculation has an error and needs to be corrected.

Answer

The [Customer Name] field is being used as a continuous measure.

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

IF YEAR([Order Date]) = YEAR(TODAY()) THEN [Sales] END

Answer

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

Answer

IF ATTR(YEAR([Order Date])) = WINDOW_MAX(MAX(YEAR([Order Date]))) THEN SUM([Sales]) END

Question 6

An analyst is comparing the performance of individual products. The view shows `SUM(Sales)` by `[Product Name]`. They want to add a column that shows the average sales for the `[Sub-Category]` that each product belongs to. What is the most direct way to create this calculation?

Accepted Answer

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

Answer

{INCLUDE [Product Name] : AVG([Sales])}

Answer

AVG([Sales])

Answer

TOTAL(AVG([Sales]))