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

It aggregates all values in the database ignoring the current view entirely

Answer

It computes a grand total by querying across all rows in the data source

Answer

It calculates a running total from the first row through the current row

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

Copy the calculated fields manually between workbooks using the Tableau Desktop clipboard

Answer

Store calculations in a shared Tableau Prep flow for universal access

Answer

Define calculations as workbook-level parameters and export them

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

When a filter needs to be applied after the aggregation completes

Answer

When working with non-additive measures like distinct counts across a blend

Answer

When the calculation needs to span across blended data sources

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

IF / THEN / ELSEIF / END

Answer

IIF() with nested conditions

Answer

SWITCH() function

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 throws a calculation error because nested LODs are unsupported

Answer

Both LOD expressions execute in parallel and their results are merged

Answer

Only FIXED LODs support nesting; INCLUDE and EXCLUDE cannot be nested

Question 6

In Tableau's Quick Table Calculations, which calculation shows how much each value differs from the value of the preceding mark in the addressing direction?

Accepted Answer

Difference From

Answer

Running Total

Answer

Percent of Total

Answer

Moving Average

Question 7

What does the Tableau ATTR() aggregation function return when the underlying data contains multiple different values for the field within the current view's level of detail?

Accepted Answer

An asterisk (*) indicating that the field is not uniquely defined at this granularity

Answer

The most frequently occurring (mode) value among all rows

Answer

The first alphabetical value found in the dataset

Answer

NULL, suppressing the field from display entirely