transformations:createbuckets
This is an old revision of the document!
Create Buckets
Creates numerical ranges of fixed width and assigns each row to one of the ranges based on values in specified column.
The action is typically used for grouping number values (such as age) by intervals of fixed width (e.g. age group). Created group labels can later be used in reports and charts.
Example
Table before:
| Age |
|---|
| 23 |
| 29 |
| 19 |
| 34 |
| 35 |
| 41 |
Objective: create buckets of 10 year width and assign a bucket to each age.
Table after:
| Age | Age group |
|---|---|
| 23 | 20 .. 30 |
| 29 | 20 .. 30 |
| 19 | 10 .. 20 |
| 34 | 30 .. 40 |
| 35 | 30 .. 40 |
| 41 | 40 .. 50 |
transformations/createbuckets.1606515552.txt.gz · Last modified: 2020/11/27 17:19 by dmitry