GROUPBYBIN

Syntax

GROUPBYBIN(<numeric>;<integer>)

Description

This function groups selected values into bins created at a specified size. The second value is the size of the bin.

This is a group series function.

The GROUPBYBIN argument value can also accept date values though not officially supported and not all date/time parse patterns are available to describe the bin size. Date values are defined by millisecond so that 3,600,000 ms is equal to 1 hour. Simple time/date parse patterns that can be described in milliseconds return correct bin sizes.

Examples:
s = second, m = minute, h = hour, d = day

It isn't possible to create a "month" bin size but is possible to create a bin with a 30 day size.

Example

GROUPBYBIN(<Column1>;<100>)

Column1Results
456300
789400
342700
419
738