Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

...

Info
titleINFO

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.

...