Categorize Numeric Field Values into Buckets

Use a bucket field to categorize and organize numeric values. For example, to group by region, you can create buckets High, Middle, Low to group numbers of cases per account.

1. In the Transform node, select the measure field in the Preview tab.
2. In the Transform toolbar, click the Bucket button () to define the buckets.
   
3. For Range 1, enter a value and label for the first bucket. Rows with values below the Range 1 value are assigned to this bucket.
   
4. If your bucket field has more than two buckets, click Add Range>> to add a middle range.
5. For each additional middle range that you add, enter the range of values and the bucket label. Rows with values greater than or equal to the first value and less than the second value are assigned this bucket.
6. For the final range, enter a value and bucket label. Rows with values greater than or equal to this value are assigned to this bucket.
   
7. To place null values into their own bucket, select Bucket null values.
8. Under Show Results In, select whether the buckets should appear in a new field and what should happen to the original field.
9. If you elect to create a field, set the label under Field Label.
10. Click Apply to add the transformation to the Transform node. The Preview tab shows the new bucket field.
11. To view the canvas, click the Collapse button ().
12. Click Save.