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

Calculated fields can reference parameters, but parameters cannot reference calculated fields

Answer

Calculated fields support only numeric data while parameters support all data types

Answer

Parameters are stored in the data source while calculated fields exist only in workbooks

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

DATETRUNC('month', [Order Date])

Answer

DATEDIFF('month', [Order Date], TODAY())

Answer

WINDOW_MIN(MIN([Order Date]))

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

The overall column average directly from the database

Answer

A moving average based on a calendar-defined date range

Answer

The aggregate average for each dimension partition independently

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

It determines the traversal order of rows for the calculation

Answer

It specifies which dimensions are included in the aggregate before the calculation

Answer

It sets the filter applied to data before the table calculation executes

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

The context filter converts FIXED LOD expressions into INCLUDE LOD behavior

Answer

The context filter removes the need for LOD expressions in that view

Answer

Context filters have no effect on FIXED LOD expressions

Question 6

What is the output of the Tableau ZN() function when applied to a field that contains a NULL value?

Accepted Answer

It replaces the NULL with zero (0)

Answer

It converts the NULL to an empty string

Answer

It normalizes the value between 0 and 1

Answer

It excludes the NULL from subsequent aggregations

Question 7

Which Tableau expression correctly calculates the year-over-year sales growth percentage using a table calculation?

Accepted Answer

(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1))

Answer

(SUM([Sales]) - SUM([Sales])) / SUM([Sales]) * 100

Answer

DATEDIFF('year', [Order Date], TODAY()) * SUM([Sales])

Answer

{FIXED YEAR([Order Date]) : SUM([Sales])} / {FIXED : SUM([Sales])}