Calculations and Parameters Flashcards
7 cards from real Tableau practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Calculations and Parameters flashcards as text
Which function converts a number into a string in Tableau?
Answer: STR()
STR() converts its argument to a string data type.
What does ZN([Profit]) return when Profit is null?
Answer: 0
ZN() returns zero in place of null values for numeric fields.
Which type of parameter control allows the user to slide through values within a defined min and max?
Answer: Range / slider
A slider control lets the user move through a continuous range between a minimum and maximum.
Which LOD expression would you use to compute average sales per customer regardless of view dimensions?
Answer: {FIXED [Customer]: AVG([Sales])}
FIXED [Customer] computes per customer independent of the view's other dimensions.
What does the FIRST() table calculation function return?
Answer: Offset from the current row to the first row
FIRST() returns the number of rows from the current row back to the first row in the partition.
Which logical function evaluates multiple conditions and returns the first true result?
Answer: IF/ELSEIF
An IF/ELSEIF/ELSE block evaluates conditions in order and returns the first matching branch.
When you reference a parameter in a calculated field, what happens when the user changes the parameter value?
Answer: The calculation recomputes with the new value
Calculations using a parameter automatically recompute when the parameter value changes.