Aggregation and total using

As you know, Tableau aggregates the Measure when you use it. By default, Tableau usually uses a sum. With the Aggregation default property, you can change that. For example, in the Sample Superstore Excel file, Discount is not a Measure that you can sum. You can change the default Aggregation to Average

Total using is quite similar; here, you can specify the aggregation used to display totals.

That's it for the default properties. These options are used to increase your speed in Tableau and are helpful if you want to share your Data Source. Another great way to customize your Data Source is to add hierarchies. 

Get Getting Started with Tableau 2018.x now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.