Analytics
Numeric Binning
Puts each number into a labelled range — equal-width bins, bins with the same number of rows, or edges you choose such as 0-100, 100-500, 500+.
When to use it
Use it to turn a measure into bands for reporting or grouping: order size bands, age groups, score ranges. Follow it with Summarize or Cross Tab to count rows per band.
In a pipeline
File InputNumeric BinningCross Tab
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Bins | select | — | width |
| Number of bins | number | — | 4 |
| Bin edges | text | — | e.g. 0, 100, 500 |
| Generate New Column | checkbox | — | true |
| New Column Name | text | — | Default: <column> Bin |
| Insert After | select | — | After the binned column |
Example
Order size bands
- Column=Total
- Bins=Custom edges
- Bin edges=0, 100, 500
| Order | Total |
|---|---|
| A-1041 | 45 |
| A-1042 | 250 |
| A-1043 | 800 |
| A-1044 | 100 |
| Order | Total | Total Bin |
|---|---|---|
| A-1041 | 45 | 0-100 |
| A-1042 | 250 | 100-500 |
| A-1043 | 800 | 500+ |
| A-1044 | 100 | 100-500 |
Worth knowing
- Each bin includes its lower edge and stops just before the next: 100 falls in 100-500. Values below the first edge are labelled <first edge.
- Edges can be a comma list (0, 100, 500) or JSON ([0,100,500]) and must go up from left to right.
- Equal frequency keeps equal values in the same bin, so bins can differ in size when many values repeat.
- Untick Generate New Column to replace the numbers with their bin labels.