What is Bin

Creating Bin is required when you are going to use discrete measure values as dimension. Using Create Bin Support, you can convert measure column as dimension column in the Syncfusion Dashboard Designer.

Consider an example table, Employee Table contains Employee_ID, Employee_Name, Age, and Salary columns. You can create a view by binding the age in the column and salary in the value. You can create a numeric dimension (discrete values) for age measure column using the following table.

Employee_ID	Employee_Name	Age	Salary
E1	James	23	15000
E2	John	26	17000.55
E3	Robert	30	18500
E4	Michael	33	20000
E5	William	37	250000
E6	David	41	240000

Consider the age field as set of bins i.e, you can group the measure values based on defined bin size. You can get the total salary between the defined age range.

How to create a bin

You can create a numeric dimension using the Create Bin option in the Data Source menu.

NOTE

The Create Bin option will be enabled from the data source tab.

To create bin, click Create Bin option in the Data Source menu.

The Create Bin window will be opened as follows.

Click Add to create a bin.

You can select the measures column listed in the Measures drop-down list.

You can edit the Bin Name and Bin Size as follows.

Click Save to create a bin.

Click the Close button or Close icon to close the Create Bin window.

The bin column will be added to the data preview grid as follows.

Editing a created bin

You can edit the Bin Name and Bin Size for the bin.

Click Update to save the changes.

Deleting a created bin

You can delete a bin by clicking Delete.

Configuring bin column in widgets

The bin will be shown in the Dimension section of the Data tab of the widget as follows.

You can drag and drop the bin column into widgets like other fields.

Here, Bin1 is bound in the column like dimension field and the Salary column is bound in the value.

The output will be obtained as follows.

NOTE

You can use the Histogram Chart to understand the Create Bin support as shown above.