You need every instance of the numeric field Price to aggregate as an average when first placed on any worksheet, instead of Tableau's default SUM. Which Tableau Desktop action sets this behavior at the data source level?
Change the data type of Price to Attribute so that Average becomes the default.
In the Data pane, right-click Price and choose Create ➜ Measure ➜ Average.
Drag Price into a worksheet, set its pill to AVG, and click Apply to Data Source.
In the Data pane, right-click Price and choose Default Properties ➜ Aggregation ➜ Average.
Tableau lets you override many default field behaviors in the Data pane. By right-clicking a field and choosing Default Properties > Aggregation, you can select a different aggregation-such as Average-that Tableau will use every time the field is initially added to a view. Creating a new calculated measure or changing the aggregation only inside a single worksheet does not change the field's default, and no data type called Attribute exists. Therefore, choosing Default Properties > Aggregation > Average is the correct approach.
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 aggregation and calculated measures in Tableau?
Open an interactive chat with Bash
Why doesn't changing the aggregation of a field in a single worksheet change its default behavior?
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 .