Recall & Review
beginner
What is a row-level calculation in Tableau?
A row-level calculation is a formula that is applied to each individual row of data before any aggregation happens. It processes data row by row.
Click to reveal answer
beginner
What does an aggregate calculation do in Tableau?
An aggregate calculation summarizes data by combining multiple rows into a single value, like sum, average, or count.
Click to reveal answer
intermediate
Example: SUM([Sales]) vs [Sales] * 0.1 - which is aggregate and which is row-level?
SUM([Sales]) is an aggregate calculation because it adds up sales across rows. [Sales] * 0.1 is a row-level calculation because it multiplies each row's sales by 10%.
Click to reveal answer
intermediate
Why can aggregate calculations not be used inside row-level calculations directly?
Because aggregate calculations summarize data across rows, they don’t have a single value per row. Row-level calculations need a value for each row, so aggregates can’t be used directly inside them.
Click to reveal answer
intermediate
How does Tableau handle the order of row-level and aggregate calculations?
Tableau first computes row-level calculations for each row, then applies aggregate calculations on the results of those row-level calculations.
Click to reveal answer
Which of the following is a row-level calculation in Tableau?
✗ Incorrect
Subtracting Cost from Profit happens for each row individually, so it is a row-level calculation.
What does SUM([Sales]) represent in Tableau?
✗ Incorrect
SUM([Sales]) adds sales values across rows, so it is an aggregate calculation.
Why can you not use SUM([Sales]) inside a row-level calculation directly?
✗ Incorrect
SUM aggregates data across rows, so it does not produce a value for each individual row needed in row-level calculations.
Which calculation happens first in Tableau?
✗ Incorrect
Tableau computes row-level calculations first, then applies aggregate calculations on those results.
If you want to calculate 10% commission on each sale, which calculation type should you use?
✗ Incorrect
Calculating 10% commission on each sale requires multiplying each row's sales value, so it is a row-level calculation.
Explain the difference between aggregate and row-level calculations in Tableau.
Think about whether the calculation happens before or after combining rows.
You got /4 concepts.
Describe a real-life example where you would use a row-level calculation versus an aggregate calculation.
Consider if you want to work with individual data points or summaries.
You got /3 concepts.