Calculated Fields and LODs Flashcards

Which LOD expression is best for computing total sales per customer regardless of the date dimension in the view?

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

FIXED [Customer] pins the aggregation to the customer level only, ignoring the date dimension.

What does an empty-dimension FIXED expression like {FIXED : SUM([Sales])} return?

Answer: The grand total of sales across the whole data source

With no dimensions specified, FIXED computes a single grand-total value for the entire data set.

Which function returns the running total within a partition and is a table calculation rather than an LOD?

Answer: RUNNING_SUM()

RUNNING_SUM is a table calculation that accumulates values along the addressing direction.

To find how many days between two dates in a calculated field, which function is correct?

Answer: DATEDIFF('day', [Start], [End])

DATEDIFF returns the difference between two dates in the specified unit.

What happens when you place an LOD expression result on the Color shelf in a continuous form?

Answer: It is treated as a measure and can be aggregated

An aggregated LOD acts like a measure and can be placed on shelves and aggregated as usual.

Which is true about nested LOD expressions?

Answer: An LOD can contain another LOD expression inside it

Tableau supports nesting LOD expressions, where an inner LOD feeds an outer one.

What is the difference between EXCLUDE and FIXED when a context filter is applied?

Answer: Both respect context filters, but EXCLUDE still depends on view dimensions

Both FIXED and EXCLUDE respect context filters; EXCLUDE additionally removes dimensions relative to the current view.