Aggregation Type (Term Mapping)

The Property named Aggregation Type is available when you edit a Term Mapping.

It allows you to configure an aggregation for the mapping's Target Term.

For example, you can add a Group by or a Sum clause.

The Native Data Type is a List of values.

The available options are:

-: No aggregation
Avg: Returns the average value of a numeric expression over the selected rows or groups.
Distinct Count: Counts unique non‑NULL values in an expression, ignoring duplicates so each distinct value is counted once.
Sum: Returns the total of a numeric expression over the selected rows or groups.
Group By: Groups rows sharing column values, so aggregate functions compute per group.
Min: Returns the smallest value of an expression over the selected rows or groups.
Count: Returns the number of rows or non‑NULL values in the specified expression.
Max: Returns the largest value of an expression over the selected rows or groups.
Expression: Any valid SQL calculation, column, or function whose result can be aggregated.

Example:

The default value is -.