# 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