TCC Calculations and Expressions 1 — Questions and Answers
Question 1: Which type of Tableau expression computes a result at a specified dimension level regardless of the filters applied to the current view?
- INCLUDE LOD expression
- FIXED LOD expression (Correct answer)
- EXCLUDE LOD expression
- Running Total table calculation
Correct answer: FIXED LOD expression
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?
- {INCLUDE [Region] : AVG([Profit])}
- {FIXED [Region] : AVG([Profit])} (Correct answer)
- {EXCLUDE [Region] : AVG([Profit])}
- AVG(FIXED [Region] : [Profit])
Correct answer: {FIXED [Region] : AVG([Profit])}
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?
- Data source calculations
- Extract calculations
- Table calculations (Correct answer)
- Row-level calculations
Correct answer: Table calculations
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?
- A value from a data source record located by primary key
- The value of an expression in a target row offset relative to the current row (Correct answer)
- A string match found within another string field
- A VLOOKUP-style result across blended data sources
Correct answer: The value of an expression in a target row offset relative to the current row
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?
- FIXED
- EXCLUDE
- INCLUDE (Correct answer)
- CONTEXT
Correct answer: INCLUDE
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.
Question 6: How does a FIXED LOD expression interact with a standard dimension filter in Tableau's order of operations?
- FIXED LOD runs after dimension filters are applied
- FIXED LOD runs before dimension filters are applied (Correct answer)
- FIXED LOD and dimension filters execute simultaneously
- FIXED LOD respects dimension filters by default without any configuration
Correct answer: FIXED LOD runs before dimension filters are applied
In Tableau's order of operations, FIXED LOD expressions are evaluated before dimension filters, so they compute on unfiltered data unless the filtered dimension is promoted to a context filter.
Question 7: Which of the following is the most appropriate use case for an EXCLUDE LOD expression in Tableau?
- Computing sales totals independent of all dashboard filters
- Calculating a percent of total that removes a specific dimension from the computation (Correct answer)
- Adding a more granular dimension to the current calculation scope
- Replicating the behavior of a running total across partitions
Correct answer: Calculating a percent of total that removes a specific dimension from the computation
EXCLUDE LOD expressions remove a specified dimension from the view's level of detail, which is ideal for computing aggregates like percent of total that should ignore one dimension.
TCC Calculations and Expressions 1
Which type of Tableau expression computes a result at a specified dimension level regardless of the filters applied to the current view?