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.
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.