Aggregation functions perform a calculation on a data and return an individual value based on a set of values.
It is helpful when you need to represent an individual value to describe you analysis results. For example, if you have a 500 sales transactions from 10 products, you might want to get a sum of sales for each product to find out what product is more relevant to produce.
When adding a measure that contains numerical values (Number type of a column) you are able to aggregate the values with one of the following ways:
| Aggregation function | Description | Result for measure contains values
3, 5, 6, 5, 7 |
| Sum (SUM) | Values are summed up, the total value is displayed. | 26 |
| Average (AVG) | Values are summed up and divided by the number of values. Average value is displayed. | 5,2 |
| Minimum (MIN) | Minimum value is displayed. | 3 |
| Maximum (MAX) | Maximum value is displayed. | 7 |
| Distinct count (DCOUNT) | The number of unique values is counted and displayed. | 4 |
| Median (MEDIAN) | Values are sorted ascendingly, the middle value of the ordered row is displayed. | 5 |
For all of the aggregations (excepting SUM) a type of aggregation is represented in a chart.
