<< Click to Display Table of Contents >> Current:  Create Data Set > Self-Service Data Set > Data Governance  Create Data Binning

Data Binning is a dimensional field used for creating a range for a numeric field. Therefore the Data Binning field is automatically added to the dimension folder. Select a numeric type field and click More icon on the Metadata page and choose "New Data Binning" from the context menu, as shown in the following figure.

You can also More icon on the column header of a numeric type field on Detail Data page and choose "New Data Binning" from the context menu.

In the displayed dialog, you can modify the name, type, boundary, minimum value, maximum value, and step value of the data range.

[Original Column] field used for creating Data Binning

[Name] column name of the data binning, "Numeric Range" by default

 

When "Ranges" is selected as the type,

[Minimum] minimum value of the data binning

[Maximum] maximum value of the data binning

[Step] step value of the data binning

[Include values less than min] If you do not select this, the values less than the minimum value will be mapped as null. Otherwise, the values less than the minimum value will be mapped as the minimum value minus the step value.

[Include values more than max] If you do not select this, the values greater than the maximum value will be mapped as null. If you select this, the values greater than the maximum value will be mapped as the maximum value plus the step value.

[Only include left boundary] The data binning includes the left boundary but not the right boundary.

[Only include right boundary] The data binning includes the right boundary but not the left boundary.

 

When "Group" is selected as the type,

[Defined Tick] Define the scale value.

[Add] Add the defined scale.

[Delete] Delete the added scale.

[Label] Set the alias for the added scale range.

 

➢For example:

The following figure shows how to set a data range for the Grade column, with the minimum value of 60, step value of 10, maximum value of 100, values less than the minimum value included, and left boundary rather than right boundary included in the range.

 

The following figure shows the mapping result on the table. Because "Include values less than min" is selected, scores less than 60 are mapped as 50. Because "Only include right boundary" is selected, 70 is mapped as 60. If "Only include left boundary" is selected, 70 is mapped as 70.

When a new Data Binning column is created, the column will be automatically selected. The vertical scroll bar will slide to the new column and select the new column.

To edit or delete a created data range field,click More icon of column, and choose item as needed.