Tableau Calculated Fields and LODs 2

Question 1

Which LOD expression computes a value at a coarser level of detail than the view, ignoring the dimensions in the view except those listed?

Accepted Answer

FIXED

Answer

FIXED computes a value using only the specified dimensions, regardless of any other dimensions in the view.

Question 2

In the order of operations, where do FIXED LOD expressions get evaluated relative to dimension filters?

Accepted Answer

Before dimension filters

Answer

FIXED LODs are computed before dimension filters are applied, so those filters do not affect them unless added to context.

Question 3

Which function would you use to convert a string '2026-01-15' into a date value in a calculated field?

Accepted Answer

DATEPARSE or DATE

Answer

DATE() or DATEPARSE() converts string input into a proper date data type.

Question 4

What does the calculated field SUM([Sales]) / SUM([Profit]) produce compared to AVG([Sales]/[Profit])?

Accepted Answer

An aggregate ratio of totals vs. an average of row ratios

Answer

SUM/SUM aggregates first then divides, while AVG of row ratios averages each row's ratio—usually different values.

Question 5

Which keyword makes an INCLUDE LOD differ from the view's grain?

Accepted Answer

It adds dimensions into the calculation not present in the view

Answer

INCLUDE computes at a finer grain by adding the listed dimensions, then aggregates up to the view level.

Tableau Practice Test