Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUPBYBIN(<numeric/date>;<integer>)

Description

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

When the column being grouped into bins is a date type, you can use the constants (ms)milliseconds, (s)seconds, (m)minutes, (h)hours, and (d)days to create the bin size.

This is a  group series function .

Example

GROUPBYBIN(<Column1>;<100>)

Column1Results
456300
789400
342700
419 
738 

 

GROUPBYBIN(<Column1>;<3d>)

Column1Results
Jan 18, 2014Jan 1, 2014
Jan 16, 2014Jan 4, 2014

Jan 13, 2014

Jan 13, 2014

Jan 20, 2014

Jan 16, 2014
Jan 28, 2014Jan 19, 2014
Jan 4, 2014Jan 25, 2014
Jan 3, 2014Jan 28, 2014

Jan 2, 2014

 
Jan 26, 2014 
Jan 14, 2014 

 

 

  • None