Supported aggregation functions with DirectQuery
This table lists aggregation functions
existing in ActivePivot and their support level with DirectQuery.
Note that the support can depend on whether the aggregation function is applied on simple scalar numbers (such as integers or floating points) or on vectors (where the numbers are grouped into arrays).
The following notations are used:
Symbol | Meaning |
---|---|
fully supported | |
partially supported | |
not (yet) supported | |
will not be supported |
Function Name | Scalar | Vectorized | Documentation | Additional DirectQuery notes |
---|---|---|---|---|
ApproxCountDistinct | Approximate count of distinct contributions. | Being an approximation, values can differ between databases. Not supported by MS SQL 2017 | ||
Average | Average of numbers. | |||
Count | Count contributions. | |||
DistinctCount | Count of distinct contributions. | Partially supported in BigQuery, Clickhouse and Snowflake. Unsupported with Synapse. | ||
GrossSum | Sum aggregation of the absolute value of numbers. | |||
Long | Sum aggregation of positive numbers. | |||
Max | Maximum of numbers. | |||
Min | Minimum of numbers. | |||
MaxHistory | Maximum of numbers with history. | |||
MinHistory | Minimum of numbers with history. | |||
Multiply | Multiplication of numbers. | As it is not a standard aggregation in databases, it is emulated by DirectQuery and can result in slightly off results. | ||
Population Std | Population standard deviation | |||
Population Variance | Population variance | |||
Sample Std | Sample standard deviation | |||
Sample Variance | Sample variance | |||
SingleValue | With all values equals, select only one. | It can be emulated with aggregation functions Min or Max | ||
Short | Sum aggregation of negative numbers. | |||
SquareSum | Sum aggregation of the square of numbers. | |||
Sum | Sum of numbers. |