You create a single-bar view that displays SUM(Sales) for the whole data source. Next, you drag the dimension Region onto Rows. How does Tableau adjust the existing SUM(Sales) measure after the dimension is added?
Tableau divides the original total Sales value equally among all Regions shown.
Tableau automatically switches the aggregation from SUM to AVG and shows the average Sales for each Region.
The original total sum remains and each Region is merely labelled on the single bar.
Tableau recomputes the sum of Sales separately for every Region, producing one bar per Region.
Adding a dimension increases the level of detail in the view. Tableau therefore recalculates the aggregation for each distinct value of the new dimension, creating separate marks that each show the sum of Sales for one Region. The total bar is not retained, the numbers are not split evenly, and the aggregation type (SUM) does not change automatically-only its computation level changes.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does 'level of detail' mean in Tableau?
Open an interactive chat with Bash
Does the aggregation type change automatically when adding a dimension in Tableau?
Open an interactive chat with Bash
What happens to the original total when a dimension is added?
Open an interactive chat with Bash
Tableau Desktop Foundations
Understanding Tableau Concepts
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .