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.
|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.|