ReferenceSQL ReferenceAggregate Functions

histogram

Calculates an adaptive histogram with up to the specified number of bins over the input values, returning an array of (lower, upper, height) tuples.

Calculates an adaptive histogram with up to the specified number of bins over the input values, returning an array of (lower, upper, height) tuples.

groupUniqArray

Creates an array from different argument values.

intervalLengthSum

Takes multiple numeric ranges and calculates the total length when all overlapping parts are combined into a single unified range.