Tableau practice: The aggregation boundary and core aggregates
Chapter 9 · 5 questions · included in full access
Question 1 · easy
The cannot mix rule
Solve it in your browserWhy does writing
SUM([Sales]) / [Units]produce a compilation error in Tableau?Question 2 · easy
Total company profit
Solve it in your browserCreate Total Profit: compute total sales minus total cost across all marks:
SUM([Sales]) - SUM([Cost]).Question 3 · easy
The ATTR asterisk
Solve it in your browserWhat does an asterisk (
*) indicate when theATTR()function is applied to a dimension inside a view mark?Question 4 · medium
Unique customer count
Solve it in your browserCreate Active Customers: count the number of distinct customers who purchased in each mark:
COUNTD([Customer]).Question 5 · medium
Average order value
Solve it in your browserCreate Avg Order Value: total sales divided by the distinct number of orders:
SUM([Sales]) / COUNTD([Order ID]).
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing