Showing aggregate measures
Tableau, by default, aggregates measure values, and this behavior can be changed to show all individual values of the measures by clicking on the Analysis menu option from the top toolbar and unchecking Aggregate Measures to remove aggregation. It is also possible to change the aggregation type, such as total, average, variance, and others.
Getting ready
Let's use the sample file Sample – Coffee Chain (Access). Open a new worksheet and select Sample – Coffee Chain (Access) as the data source.
How to do it...
Once the data is loaded, perform the following steps to change and add various aggregate measures:
- Make sure the Aggregate Measures option is checked under the Analysis menu option on the top toolbar.
- Drag-and-drop Product ...
Get Tableau: Creating Interactive Data Visualizations 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.
