A data analyst frequently uses the 'Profit' field, which defaults to SUM aggregation. To ensure every new instance of the 'Profit' field in the workbook defaults to Average instead, what is the correct method to use?
Create a new calculated field with the formula AVG([Profit]) and use this new field for all subsequent visualizations.
In the Data pane, right-click the 'Profit' field, select 'Default Properties', then 'Aggregation', and choose 'Average'.
On the Data Source page, right-click the 'Profit' column and select the 'Average' aggregation from the properties.
Drag the 'Profit' field to the view, right-click the pill, and change its aggregation to 'Average' from the context menu.
The correct method to change the default aggregation for a field is to right-click on the field in the Data pane, navigate to 'Default Properties', and then select the desired aggregation. This action sets the default behavior for the field across the entire workbook for all future uses. Changing the aggregation on a pill in a view only affects that specific instance. Creating a new calculated field is a workaround that creates an entirely new field. The Data Source page is used for managing the data model, not for setting default visualization properties like aggregation.
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 are Default Properties in Tableau?
Open an interactive chat with Bash
What is the difference between changing aggregation in a view vs. in Default Properties?
Open an interactive chat with Bash
Why can't you change aggregation on the Data Source page in Tableau?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
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 .