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. |
Comments
0 comments