Tableau-Desktop-Found Understanding Tableau Concepts Practice Question
Which of the following actions is the most efficient way to change the default aggregation of a measure?
⚠ Common exam trap
Many candidates manually change the aggregation on the pill in the view for every single chart, unaware that setting it in the Data pane provides a permanent global default for that field.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Right-click the measure in the Data pane and select Default Properties > Aggregation.
Changing the default aggregation at the field level is a best practice that ensures consistency across all future visualizations using that field. It avoids the need to manually change the aggregation every time a measure is dropped onto a shelf. This efficiency improves workflow speed and minimizes the risk of human error, which is critical when maintaining large dashboards where standardized metric definitions are required for stakeholders.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Right-click the measure in the Data pane and select Default Properties > Aggregation.
Why this is correct
Setting the aggregation via the Default Properties menu in the Data pane updates the field globally for the workbook. This is the most efficient method, as it ensures that every subsequent use of that measure will automatically apply the desired aggregation, such as Average instead of Sum.
- ✗
Create a new calculated field for every visualization that uses the measure.
Why it's wrong here
Creating redundant calculated fields for simple aggregation changes creates unnecessary overhead and complicates the workbook metadata. It is inefficient and hard to maintain, as updating the logic would require editing multiple fields instead of simply changing the default property for the base measure once.
- ✗
Update the data source file directly to include a new aggregated column.
Why it's wrong here
Modifying raw data sources to include aggregated values is considered a poor practice in Tableau. It reduces the flexibility of the data, as it prevents users from drilling down into the underlying raw records. Tableau's built-in aggregation features are designed to handle this dynamically without changing raw data.
- ✗
Drag the measure to the Marks card and manually select the aggregation each time.
Why it's wrong here
Manually changing the aggregation every time a field is used is inefficient and error-prone. This approach increases the likelihood of inconsistencies across dashboard views, as it depends on the user remembering to perform the step for every instance, which is not a scalable workflow for professional reporting.
About these practice questions
Courseiva writes every Tableau-Desktop-Found question from scratch — 126 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Tableau (Salesforce) exam blueprint
This Tableau-Desktop-Found practice question is part of Courseiva's free Tableau (Salesforce) certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Tableau-Desktop-Found exam.