<< Click to Display Table of Contents >> Current:  Common Analysis Scenarios  How to Create Data Binning

The data binning is to create a binningd dimension field for a numeric type field. Therefore, this field is automatically included under the node of the dimension.

 

1.After the data source is set up, click [Refresh Metadata] and all data fields will be displayed in the metadata area.

2.In the metadata area, select the field of the numberic type. In the corresponding "More" menu, select [Create Numberic binning].

3.In the Create Numberic binning window, enter the data binning name, set the boundary, enter the minimum, maximum, and step information, and then click [OK].

➢Note:

Minimum: Set the minimum value of the data binning.

Maximum: Set the maximum value of the data binning.

Step: Set the step size of the data binning.

Include values less than min: When the user does not check, the value less than the minimum value will be mapped to null. When checked, values less than the minimum value will be mapped to the minimum minus the step value.

Include values more than max: When the user does not check, the value greater than the maximum value will be mapped to null. When checked, values greater than the maximum value will be mapped to the maximum plus the step value.

 

4.The new data binning appears in the dimension area.