TCC Calculations and Expressions 3

Question 1

What is the primary purpose of the TOTAL() function within a Tableau table calculation?

Accepted Answer

It returns the sum of values across the entire current partition of a table calculation

Answer

TOTAL() returns an aggregate (defaulting to SUM) of the expression across the entire current partition, making it useful for computing percentages of total within each partition.

Question 2

What is the most effective way for a Tableau consultant to reuse calculated fields consistently across multiple workbooks connecting to the same data?

Accepted Answer

Embed the calculations in a published data source on Tableau Server or Cloud

Answer

Embedding calculations in a published data source ensures that any workbook connecting to that source automatically inherits the calculations, enforcing consistency and a single source of truth.

Question 3

When should a Tableau developer use a FIXED LOD expression instead of a standard aggregate measure in the view?

Accepted Answer

When the required aggregation granularity is coarser than the current view's level of detail

Answer

FIXED LOD expressions are the right tool when you need to aggregate at a higher (coarser) granularity than what the view displays, such as computing a per-customer average while the view shows individual orders.

Question 4

Which Tableau calculation construct is best suited for evaluating a single dimension field against multiple specific discrete values and returning a corresponding result for each?

Accepted Answer

CASE / WHEN / THEN / END

Answer

CASE/WHEN is optimized for matching a single expression against a list of specific values, producing cleaner and more readable syntax than nested IF/ELSEIF chains for this pattern.

Question 5

What happens when a Tableau LOD expression is nested inside another LOD expression?

Accepted Answer

The inner LOD is resolved first, and its result is available as input to the outer LOD

Answer

Tableau supports nested LOD expressions; the inner expression is evaluated at its declared granularity first, and the resulting value is then used within the outer LOD expression's computation.

TCC - Tableau Certified Consultant Practice Test

TCC - Tableau Certified Consultant Practice Test

TCC Calculations and Expressions 3