Aggregate Functions
Executes a predefined function and returns an aggregate
for a set of values based on the function values.
Note: You can access aggregate functions through calculated
categories, calculated measures and dimension calculations. You cannot
access them through calculated columns.
| Aggregate | Description |
|---|---|
| Returns the average value. |
|
| Returns the difference over a linear series of categories by calculating the change between each pair of categories. |
|
| Returns the maximum value of selected data items. |
|
| Returns the minimum value of selected data items. |
|
| Returns the percent of the total value for selected data items. |
|
| Percent-growth | Returns the growth over a linear series of categories by calculating the percentage change between each pair of categories. |
| Returns the values of categories as a percent share of other target categories. |