Tableau-Desktop-Found Understanding Tableau Concepts Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  Change the default aggregation of the 'Shipping Cost' field to Average by right-clicking the field in the Data pane and selecting Default Properties > Aggregation > Average.

  Why it's wrong here

  This changes the default aggregation for the field across all future uses, which alters the field's behavior globally. The analyst only wants the average for this specific view, not a permanent change to the data source's default. This action would affect other worksheets and could mislead other users who expect the original SUM default.

• ✗

  Create a calculated field using the formula AVG([Shipping Cost]) and replace the original field on the shelf with this calculation.

  Why it's wrong here

  While AVG([Shipping Cost]) would compute the average, it creates a new calculated field that may not aggregate correctly at the view level of detail. Tableau's AVG function is an aggregate, and mixing it with dimensions can cause errors or unexpected results. The simpler, standard method is to change the aggregation on the pill directly.

• ✗

  Right-click the 'Shipping Cost' field in the Data pane and select 'Convert to Dimension', then place it on a shelf and set the aggregation to Average.

  Why it's wrong here

  Converting a measure to a dimension changes its role entirely, treating it as categorical data rather than a quantitative measure. This would prevent proper aggregation and likely produce incorrect results. The field should remain a measure, and the aggregation should be changed on the view, not by altering its fundamental role.

• ✓

  Drag 'Shipping Cost' to a shelf, then use the drop-down menu on the pill and select Measure > Average.

  Why this is correct

  Using the pill's drop-down menu to change the aggregation to Average applies the aggregation only to that specific view. This is the correct way to display average shipping cost per order without altering the data source's default aggregation. It allows the analyst to keep the original SUM default for other uses while customizing this view.