AGGREGATE Functions

All functions > AGGREGATE

All functions in the AGGREGATE category.

Function	Description
`ANY_VALUE`	Returns an arbitrary value from the group.
`APPROX_DISTINCT`	Returns the approximate number of distinct values in the group.
`ARRAY_AGG`	Returns an array of the values in the group.
`AVG`	Returns the average of the values in the group.
`BOOL_AND`	Returns true if all values in the group are true.
`BOOL_OR`	Returns true if any value in the group is true.
`COUNT`	Returns the number of values in the group.
`COUNT_DISTINCT`	Returns the number of distinct values in the group.
`COUNT_IF`	Returns the number of values in the group that are true.
`MAX`	Returns the maximum value in the group.
`MAX_BY`	Returns the maximum value in the group by the given expression.
`MIN`	Returns the minimum value in the group.
`MIN_BY`	Returns the minimum value in the group by the given expression.
`SUM`	Returns the sum of the values in the group.

Summary

Functions in AGGREGATE: 14

This documentation is automatically generated from the FeatureMesh registry.

Suggest changes to this page

Last update at: 2025/10/13 10:23:46