Adding Numeric Equal Distance Bucketing

Numeric data is represented as a continuous set of values in displays and filters.  Sometimes it may be necessary to divide the data into equal sized bucket subsets.

For example, for the 1 Day Change % (USD) column, the minimum value is -0.35 and the maximum value is 0.21 and when you specify 2 buckets, the equal distance ranges will be the following:

• -0.35, -0.07

• -0.0.7, 0.21

Meanwhile, if you specify 3 buckets, the equal distance ranges

• -0.35, -0.17

• -0.1.7, 0.02

• 0.0.2, 0.21

These can be achieved with Equal Distance bucketing, and is commonly used when producing histograms.

Adding Numeric Equal Distance Bucketing

1. Right-click on the numeric field, and select New Bucketing Column…

The Create Bucketing Column dialog displays.

2. Select Bucketing Mode to Equal Distance, and complete the Name, and number of buckets, and click OK.

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

This can then be used in a visualizations breakdown to display data samples.