1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Prepare Data
  3. Enrich and Transform Data
  4. Create a Bin Column When You Prepare Data

Create a Bin Column When You Prepare Data

Binning a measure creates a new column based on the value of the measure. For example, you might want to assign temperature values into two bin categories for less than or equal to 70 degrees and more than 70 degrees.

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.
  1. On the Home page, open a dataset or workbook.
    • Hover over the dataset, click Actions (Actions menu ellipsis icon), and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
    • Hover over the workbook that contains the dataset, click Actions (Actions menu ellipsis icon), then 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:

    Oracle Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
  2. Select the column that you want to modify.
  3. Click Options, (Options) at the base of the column.
  4. Select Bin.
  5. 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.
  6. Click Add Step.
    Oracle Analytics adds a step to the Preparation Script panel, ready to be applied when you click Apply Script or Save Dataset.
  7. To save your data preparation changes and apply them to your data, click Save Dataset.