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 |