To use the binning tool:
Select Insert > Binned Column....
If you have more than one data table in the document, select the Data table to work on.
Select a Column to bin.
Select a Bin method:
Specific Limits
Allows you to explicitly enter values, separated by semicolons, of the limits to use for each bin.
Even Intervals
Allows you to specify the desired number of bins and divides the value range into equal intervals.
Even Distribution of Unique Values
Allows you to specify the desired number of bins and divides the bins so that each one contains an equal number of unique values.
Based on Standard Deviation
Allows you to divide the range into sections as described by the selected standard deviation multipliers.
Substring
Allows you to group the values by the first or
last characters in the column to be binned.
Values
Allows you to group categorical values into bins.
Type a New column name for the binned column.
Click OK.
Tip: Right-click on a column selector and select Auto-bin Column to create a temporary, automatic binning on an axis. Binning functions can also be used in custom expressions.
See also:
Details on Insert Binned Column