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.

ItemShort nameDefinition
NoneNone

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.

CountCount The number of elements (rows) in a set.
Count (distinct)Count d The number of unique elements (rows) in a set.
SumSum The sum of all values in a set.
AverageAvgThe sum of all values in a set divided by the number of elements in a set (Total/Count).
MinimumMinThe smallest value in a set.
MedianMedianThe value in the middle of all the values in a set, which are sorted in ascending order.
MaximumMaxThe largest value in a set.
Standard DeviationStdvedThe 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.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.