Configuring Combo Box

Combo Box enables you to filter based on single or multiple items selection in dropdown list. To bind a combo box, a minimum requirement of 1 column is needed.

How to configure table data to combo box?

The following procedure illustrates data configuration of Combo Box.

Drag and drop Combo Box widget from the tool box into design panel and resize into your required size. You can find widget in tool box by search.

Click Data Source button in configuration panel.

Click CREATE NEW button to launch a new connection from connection type panel.

In the connection type panel, click any one (Here Microsoft SQL Connection type is selected for demonstration) of the listed connection type button shown.

In the NEW DATA SOURCE configuration panel, fill the connection type and related details. Click Connect button

Drag your preferred table or view from the left pane from data design view, click Save button.

Click Properties button in configuration panel, property pane opens. Now, Switch to ASSIGN DATA tab.

The data tab will be opened with available measures and dimensions from the connected data source

Drag and drop a column from Measures or Dimensions to Columns section.

Define the Sort of the dropped column through Sort option in the Settings drop down menu. For more details refer Sort.

Define filter criteria through the Filter(s) menu item in the Settings drop down menu. For more details, refer filter.

Clear the filters by selecting the Show All Records in the Settings dropdown menu.

How to format combo box?

You can format the combo box for better illustration of the view that you require, through the settings available in Properties tab. This pane can be opened from design view through clicking the Settings icon at top right corner of the widget.

General Settings

Name

This allows you to set title for this combo box widget.

Basic Settings

Enable Multi-select

This allows you to define single/multiple item selection in dropdown list.

Single Selection

Multiple Selection

Initially, all items in combo box selected. You can select/ unselect items by checking/unchecking items.

All - This allows you to select or unselect all items in the combo box.

Allow Filter

This allows you to enable a filter box for easy filtering of data.

Filter

Act as Master Widget

This allows you to define this combo box widget as a master widget such that its filter action can be made to listen by other widgets in the dashboard.

Ignore Filter Actions

This allows you to define this combo box widget to ignore responding to the filter actions applied on other widgets in dashboard.

Container Appearance

Title Alignment

This allows you to handle the alignment of widget title to either left, center or right.

Title Color

This allows you to apply text color to the widget title.

Show Border

This allows you to toggle the visibility of border surrounding the widget.

Corner Radius

This allows you to apply the specified radius to the widget corners. Value can be between 0 and 10.

Enable Comment

This allows you to enable/disable comment for dashboard widget. For more details refer here