Tableau Calculations and Parameters 3 — Questions and Answers
Question 1: Which LOD expression ignores the dimensions in the view entirely except those specified?
- FIXED (Correct answer)
- INCLUDE
- EXCLUDE
- RANK
Correct answer: FIXED
FIXED computes using only the specified dimensions, ignoring all others in the view.
Question 2: What is the result of the expression INT(3.99) in Tableau?
- 3 (Correct answer)
- 4
- 3.99
- 0
Correct answer: 3
INT() truncates toward zero, so 3.99 becomes 3.
Question 3: Which function returns the rank of a value, leaving gaps after ties?
- RANK() (Correct answer)
- RANK_DENSE()
- RANK_UNIQUE()
- INDEX()
Correct answer: RANK()
RANK() assigns the same rank to ties and skips subsequent numbers, leaving gaps.
Question 4: How can a parameter dynamically swap which measure is shown on an axis?
- Use a CASE statement referencing the parameter (Correct answer)
- Use a FIXED LOD
- Use a RUNNING_SUM
- Use a data blend
Correct answer: Use a CASE statement referencing the parameter
A CASE or IF calculated field reads the parameter and returns the chosen measure.
Question 5: Which string function returns the number of characters in a field?
- LEN() (Correct answer)
- MID()
- LEFT()
- FIND()
Correct answer: LEN()
LEN() returns the length of a string as an integer.
Question 6: What does WINDOW_AVG(SUM([Sales])) compute by default?
- Average of summed sales across the partition (Correct answer)
- Sum of all sales
- Average row-level sales
- Running average
Correct answer: Average of summed sales across the partition
WINDOW_AVG averages the aggregated values across the entire window/partition.
Question 7: Which function tests whether a value is null?
- ISNULL() (Correct answer)
- IFNULL()
- ZN()
- ISDATE()
Correct answer: ISNULL()
ISNULL() returns true when the expression is null.
Tableau Calculations and Parameters 3
Which LOD expression ignores the dimensions in the view entirely except those specified?