TCC Calculations and Expressions 2

Question 1

What is the primary functional difference between a calculated field and a parameter in Tableau?

Accepted Answer

Parameters are static, user-controlled input values while calculated fields are dynamic expressions evaluated against data

Answer

Parameters hold a single user-selected value that can be fed into calculations, whereas calculated fields define a dynamic formula that is evaluated row-by-row or as an aggregate against the data.

Question 2

A consultant needs to assign each customer to a cohort based on the month of their very first purchase, regardless of what filters are applied to the view. Which approach is most appropriate?

Accepted Answer

{FIXED [Customer ID] : MIN([Order Date])}

Answer

A FIXED LOD expression using MIN([Order Date]) anchored to [Customer ID] computes the first purchase date per customer independent of view filters, enabling accurate cohort assignment.

Question 3

What does the WINDOW_AVG() table calculation function compute in Tableau?

Accepted Answer

The average value across the rows defined by the current addressing and windowing configuration

Answer

WINDOW_AVG() computes the average of an expression across the range of rows specified by the table calculation's addressing (start and end offsets within the current partition).

Question 4

In a Tableau table calculation configured with 'Compute Using: Specific Dimensions,' what role does the partitioning configuration play?

Accepted Answer

It defines the group of cells within which the calculation resets and restarts

Answer

Partitioning defines the boundaries of each independent group; when the table calculation moves from one partition to another, it restarts from the beginning.

Question 5

What is the effect of promoting a dimension filter to a context filter in relation to FIXED LOD expressions?

Accepted Answer

The FIXED LOD expression is now evaluated after the context filter, causing it to respect the filter

Answer

Context filters are applied before FIXED LOD expressions in Tableau's order of operations, so promoting a dimension filter to context causes FIXED LOD calculations to be scoped to the filtered data.

TCC - Tableau Certified Consultant Practice Test

TCC - Tableau Certified Consultant Practice Test

TCC Calculations and Expressions 2