3. Enter a benchmark value into the 'Value Range' field, and click the 'Add' button. Repeat until all desired benchmarks have been entered.
4. Select the 'Less Than Min' checkbox to create a bin for all values that fall below the minimum benchmark. If you do not select this option, those values are classified as “Others.”
5. Select the 'Greater Than Max' checkbox to create a bin for all values that fall above the maximum benchmark. If you do not select this option, those values are classified as “Others.”
6. Click the 'OK' button to close the dialog box.
A date range column groups dates into a fixed set of date bins. You can create a range column for any date column in a Data Table.
To create a range column, follow these steps:
1. Right-click the header of the column for which you want to create a range column, and select the 'New Range Column' option from the context menu. This opens the 'Date Range Name' dialog box.
2. Enter a name for the new column in the 'Date Range Name' dialog box, and click 'OK'. This opens the 'Date Range Option' dialog box.
3. Select the desired partitioning (year, month, quarter, etc.), and click the 'OK' button to close the dialog box.