About aggregation for measures
For measures, aggregation is a result of a calculation applied to a measure based on all the values in a set. For example, you have an Excel file with a column that contains the gross sales for each product type. By applying the SUM aggregation, you receive a single value, which is the total gross sales for all the values in the column.
The aggregation is defined during the creation of a dataset. The aggregation type that is defined at the time of a dataset creation is a default type for that measure in a visualization. The aggregation types that are available while creating a dataset are Sum, Avg, Count, Min, and Max. For details, see About data profiling and Change the data aggregation.
You can change the aggregation type of measure used for defining a visualization. To change the aggregation type for a measure, open the widget settings pane, click a measure in the Data section, and then select one of the types listed in the following table.
This type of aggregation shows unique values for a measure. The values will be grouped according to other selected columns.
This option is available in the Table widget.
The number of elements (rows) in a set.
The number of unique elements (rows) in a set.
The sum of all values in a set.
The sum of all values in a set, divided by the number of elements in a set (Total/Count).
The smallest value in a set.
The value in the middle of all the values in a set, which are sorted in ascending order.
The largest value in a set.
The amount of variation of a set of data values from its mean. A low standard deviation indicates that the data points tend to be close to the mean.