Creating a Bin Column When You Prepare Data

Binning a measure creates a new column based on the value of the measure.

You can assign a value to the bin dynamically by creating the number of equal-sized bins or by explicitly specifying the range of values for each bin. You can create a bin column based on a data element.

On the Home page, open a dataset or workbook.
- Select the dataset, click the Actions Menu , and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
- Select the workbook that contains the dataset, click the Actions Menu , select Open, then click Data. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
  Note:CIC Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets. For file-based data sources, Oracle Analytics displays the transform editor directly.
Select a column that you want to modify.
Click Options for the selected column, and select Bin.
In the Bin step editor, specify the options for the bin column.
- Enter a number or use the arrows to increment or decrement the number of bins.
- Based on your selection in the Method field, the range and count of the bins are updated.
  - In the Manual method, you select the boundary (that is, minimum and maximum) of each bin. You can also change the default name of each bin.
  - In the Equal Width method, the boundary of each bin is the same, but the count differs. Based on your selection in the Bin Labels field, the bin column labels are updated.
  - In the Equal Height method, the height of each bin is the same or very slightly different but the range is equal.
- If you select the Equal Width method, click to select a dimension (that is, an attribute data element) on which to apply the bin.
Click Add Step.
CIC Analytics adds a step to the Preparation Script pane, ready to be applied when you click Apply Script or Save Dataset.
To save your data preparation changes and apply them to your data, click Save Dataset.
If you're working with a single table dataset or a file-based dataset, click Apply Script.

Related Topics