Tableau Calculated Fields and LODs 3

Question 1

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

Accepted Answer

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

Answer

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

Question 2

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

Accepted Answer

The grand total of sales across the whole data source

Answer

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

Question 3

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

Accepted Answer

RUNNING_SUM()

Answer

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

Question 4

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

Accepted Answer

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

Answer

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

Question 5

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

Accepted Answer

It is treated as a measure and can be aggregated

Answer

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

Tableau Practice Test