Aggregate Functions

Calculates the arg value for a maximum val value. If there are several different values of arg for maximum values of val, returns the first of these values encountered.

Calculates the arg value for a minimum val value. If there are several different values of arg for minimum values of val, returns the first of these values encountered.

avgIf

Aggregate function.

The name of an aggregate function can have a suffix appended to it. This changes the way the aggregate function works.

Aggregate function.

countIf

The COUNT() function returns the number of records returned by a select query.

Aggregate function.

maxIf

Aggregate function.

minIf

Aggregate function.

Aggregate function.

sumIf

Aggregate function.

windowFunnel