/
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>)
Column1 | Results |
---|---|
456 | 300 |
789 | 400 |
342 | 700 |
419 | |
738 |
, multiple selections available,
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