GROUPBYCUSTOMBIN

Syntax

GROUPBYCUSTOMBIN(<float,integer>;<integer>)

Description

This function groups selected values into bins created at a custom sizes. In the GROUPBYBIN function only a single bin size can be created. In GROUPBYCUSTOMBIN, you can create multiple bin sizes.

This is a group series function.

Example

GROUPBYCUSTOMBIN(<Column1>;10;50;100;500)

In this example, the bin sizes created are 10, 50, 100, and 500. Column1 is the data used in the function to be sorted into bins. The function adds the values from column1 into the defined bins. The GROUPCOUNT function shows the number of values in each bin.

Column1GROUPBYCUSTOMBIN() resultGROUPCOUNT()
15102
35503
551003
755002
90

122

285

465

578

1028