Aggregation Types

The following table describes the seven column-specific aggregation types that are available. You can combine more than one type in a single request. Based on the results of a find or query, multiple aggregations can be performed over multiple columns.

Column-specific Aggregation Types

Aggregation	Constant
Sum	AggregationType.AGG_TYPE_SUM()
Minimum	AggregationType.AGG_TYPE_MIN()
Maximum	AggregationType.AGG_TYPE_MAX()
Average	AggregationType.AGG_TYPE_AVG()
Count Distinct	AggregationType.AGG_TYPE_COUNT_DISTINCT()
Average Distinct	AggregationType.AGG_TYPE_AVG_DISTINCT()
Sum Distinct	AggregationType.AGG_TYPE_SUM_DISTINCT()

In addition, there is an aggregation type for performing a count called Count* that is available through the following API:

AggregationInfo_addCount();