Tableau: Creating Interactive Data Visualizations

Aggregating data

Although the type of aggregation of a measure can be changed from the Marks pane, it is sometimes necessary to show different aggregations of the same measure, and we can do this by creating multiple aggregate fields. We can also add the same Measure field multiple times to the Rows or Columns shelf and then change the aggregation type.

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 on the worksheet, perform the following steps to create calculated fields with different aggregations:

1. Right-click on Profit from Measures, and click on Create Calculated Field.
2. In the Name box, enter Sum of ...