TCC Calculations and Expressions

Question 1

Which type of Tableau expression computes a result at a specified dimension level regardless of the filters applied to the current view?

Accepted Answer

FIXED LOD expression

Answer

FIXED LOD expressions compute at the declared dimension level and are evaluated before dimension filters, making them independent of view-level filter context.

Question 2

What is the correct Tableau syntax for a FIXED Level of Detail expression that calculates average profit per region?

Accepted Answer

{FIXED [Region] : AVG([Profit])}

Answer

FIXED LOD expressions use curly braces with the keyword FIXED, followed by the dimension declaration, a colon, and the aggregate expression.

Question 3

Which type of Tableau calculation is executed by the Tableau engine after data has been retrieved from the data source, rather than being pushed to the database?

Accepted Answer

Table calculations

Answer

Table calculations are computed by Tableau's query engine on the aggregated result set already returned from the data source, not at the database level.

Question 4

What does the Tableau LOOKUP() table calculation function return?

Accepted Answer

The value of an expression in a target row offset relative to the current row

Answer

LOOKUP() returns the value of a given expression at a row that is a specified number of positions before or after the current row in the table calculation's addressing direction.

Question 5

Which LOD expression type adds a dimension to the view's level of detail for the purpose of a finer-grained computation?

Accepted Answer

INCLUDE

Answer

INCLUDE LOD expressions add the specified dimension to whatever granularity is in the view, resulting in a finer aggregation that is then re-aggregated at the view level.

TCC - Tableau Certified Consultant Practice Test

TCC - Tableau Certified Consultant Practice Test

TCC Calculations and Expressions