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.
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.
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