# Aggregate functions

## AVG

Syntax:`AVG( value )`

Returns the average of all values. Applicable to numeric data types as well as `Date | Datetime`.

## AVG_IF

Syntax:`AVG_IF( expression, condition )`

Returns the average of all values that meet the `condition` condition. If the values don't exist, it returns `NULL`. Applicable to numeric data types only.

## COUNT

Syntax:`COUNT( [ value ] )`

Returns the number of items in the group.

## COUNT_IF

Syntax:`COUNT_IF( condition )`

Returns the number of items in the group meeting the `condition` condition.

## COUNTD

Syntax:`COUNTD( value )`

Returns the number of unique values in the group.

## COUNTD_APPROX

Syntax:`COUNTD_APPROX( value )`

Returns the approximate number of unique values in the group. Faster than COUNTD, but doesn't guarantee accuracy.

## COUNTD_IF

Syntax:`COUNTD_IF( expression, condition )`

Returns the number of unique values in the group that meet the `condition` condition.

## MAX

Syntax:`MAX( value )`

Returns the maximum value.

If `value`:

• number — Returns the largest number.
• date — Returns the latest date.
• string — Returns the last value in the alphabetic order.

## MEDIAN

Syntax:`MEDIAN( value )`

Returns the median value.

## MIN

Syntax:`MIN( value )`

Returns the minimum value.

If `value`:

• number — Returns the smallest number.
• date — Returns the earliest date.
• string — Returns the first value in the alphabetic order.

## QUANTILE

Syntax:`QUANTILE( value, quant )`

Returns the precise `value`-level quantile (`value` should be in range from 0 to 1).

## QUANTILE_APPROX

Syntax:`QUANTILE_APPROX( value, quant )`

Returns the approximate `value`-level quantile (`value` should be in range from 0 to 1).

## STDEV

Syntax:`STDEV( value )`

Returns the statistical standard deviation of all values in the expression based on a selection from the population.

## STDEVP

Syntax:`STDEVP( value )`

Returns the statistical standard deviation of all values in the expression based on the biased population.

## SUM

Syntax:`SUM( value )`

Returns the sum of all expression values. Applicable to numeric data types only.

## SUM_IF

Syntax:`SUM_IF( expression, condition )`

Returns the sum of all the expression values that meet the `condition` condition. Applicable to numeric data types only.

## VAR

Syntax:`VAR( value )`

Returns the statistical variance of all values in an expression based on a selection from the population.

## VARP

Syntax:`VARP( value )`

Returns the statistical variance of all values in an expression across the entire population.