Adding Identity Bucketing

Numeric data is represented as a continuous set of values in displays and filters.  However there are circumstances when the numeric values are not continuous, but instead discrete categories, to be grouped and filtered upon.

Numeric fields can be converted into text in the underlying data repository, but then sort order is treated as text, rather than numeric.

To group and aggregate numeric data, a numeric columns should be present in the data table.

Identity Bucketing

1. Right-click on a Numeric field and select New Bucketing Column...

The Create Bucketing Column dialog displays.

2. Select Bucketing Mode to Id, and complete the Name, format, and click OK.

Once added, the new identity bucket column will appear in the output data schema.

These new id columns can then be used as categories in the breakdown, and as categorical filters: