Tableau’s default method of aggregation for a measure is Sum. However, Sum will not always be the most appropriate method of aggregation to use.
So how do you do it?|
Using Tableau Superstore and Profit as an example:
It’s fairly straightforward to change the method of aggregation once the measure has been added to the view, it would be quicker and easier if the default aggregation method could be changed.
- Right-click on the measure you want to change the aggregation for
- Select Default Properties
- In the new menu, pick Aggregation
- Select the new default aggregation for the measure.
Now, when Profit is added to the view, it will default to the Average of Profit instead of the Sum.
I hope you found this useful and that it saves you time. (I think it’s most useful if you have to use a non-default aggregation in multiple places!)