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.

Item	Short name	Definition
None	None	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.
Count	Count	The number of elements (rows) in a set.
Count (distinct)	Count d	The number of unique elements (rows) in a set.
Sum	Sum	The sum of all values in a set.
Average	Avg	The sum of all values in a set, divided by the number of elements in a set (Total/Count).
Minimum	Min	The smallest value in a set.
Median	Median	The value in the middle of all the values in a set, which are sorted in ascending order.
Maximum	Max	The largest value in a set.
Standard Deviation	Stdved	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.