Aggregation types
An aggregation combines multiple numerical values of a criterion in one value. Criteria have a default aggregation mode based on their data type. However, you can configure the aggregation mode as needed.
You can apply the following aggregation operations to aggregate criteria values.
Aggregation | Comparison operators |
Average (AVG) | Returns the average of the values in the field to be aggregated. |
Count (CT) | Returns the count of values in the field to be aggregated. |
Count distinct values (CTD) | Returns the count of distinct values in the field to be aggregated. The result of the calculation is approximate and not exact. |
Maximum (MAX) | Returns the highest value in the field to be aggregated. |
Median (MED) | Returns the median of the values in the field to be aggregated. The result of the calculation is approximate and not exact. The median is the value separating the higher half from the lower half of a dataset. |
Minimum (MIN) | Returns the lowest value in the field to be aggregated. |
No aggregation (NOAGGR) | If no aggregation is specified, the incoming fields remain unchanged. No aggregation operation is applied to the field values. |
Ratio (RATIO) | User-defined aggregation rule that allows to calculate the ratio of a measure for specific cases or activities relative to other cases or activities. |
Standard deviation (STDDEV) | Returns the standard deviation of the values in the field to be aggregated. |
Sum (SUM) | Returns the sum of the values in the field to be aggregated. |