/
GROUPBYBIN

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.

INFO

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

Related content

Grouping Functions
Grouping Functions
Read with this
GROUPBYBIN
GROUPBYBIN
More like this
GROUPBYBIN
GROUPBYBIN
More like this
GROUPBYCUSTOMBIN
GROUPBYCUSTOMBIN
More like this
GROUPBYCUSTOMBIN
GROUPBYCUSTOMBIN
More like this
GROUPBYCUSTOMBIN
GROUPBYCUSTOMBIN
More like this