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.

Column1	GROUPBYCUSTOMBIN() result	GROUPCOUNT()
15	10	2
35	50	3
55	100	3
75	500	2
90
122
285
465
578
1028

Browser not supported