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 returns the running total of a measure across the addressing dimension?
Answer: RUNNING_SUM()
RUNNING_SUM() computes a cumulative total from the first row to the current row along the partition.
What type of calculation is computed by Tableau's data engine before aggregation, on a row level?
Answer: Row-level calculation
Row-level calculations evaluate for every individual record in the underlying data before aggregation.
Which LOD expression computes a value at a more granular level than the view?
Answer: INCLUDE
INCLUDE LOD expressions add dimensions, increasing granularity beyond what is in the view.
A parameter in Tableau can hold how many values at a single point in time?
Answer: One single value
A parameter is a single dynamic value that the user sets one at a time.
Which function would you use to extract the year from a date field?
Answer: DATEPART('year', [Date])
DATEPART('year', [Date]) returns the year as an integer.
What does the IFNULL([Sales], 0) function return when Sales is null?
Answer: 0
IFNULL returns the second argument when the first is null, so it returns 0 here.
Which calculation type is dependent on the layout and number of marks in the view?
Answer: Table calculation
Table calculations operate on the result set displayed in the view and depend on its structure.