To ensure the measure Sales automatically aggregates by average instead of sum each time it is added to a view, which Data pane workflow should you perform before building any visualizations in the workbook?
Create a calculated field WINDOW_AVG(SUM([Sales])) and set it as the default calculation.
Drag Sales onto the Data Source tab and change its data type to Decimal.
Right-click Sales, choose Convert to Dimension, then leave aggregation set to Automatic.
Right-click Sales and select Default Properties > Aggregation > Average.
In the Data pane you can change how a field behaves throughout the workbook by editing its default properties. Right-clicking the Sales field and choosing Default Properties âž” Aggregation âž” Average sets the field's default aggregation to AVG, so every new use will aggregate by average unless explicitly changed. Changing the data type, converting the field to a dimension, or creating a calculated field does not alter the field's built-in default aggregation for future uses.
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
Why would you use Default Aggregation settings in Tableau?
Open an interactive chat with Bash
Can changing the data type affect a field’s default aggregation?
Open an interactive chat with Bash
What are default properties in Tableau?
Open an interactive chat with Bash
What is the difference between a measure and a dimension in Tableau?
Open an interactive chat with Bash
Why use AVG instead of SUM for aggregation 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 .