Combo box enables you to filter the items based on single or multiple items selection in the dropdown list. To bind a combo box, a minimum requirement of 1 column is needed.
The following procedure explains the data configuration of the Combo box:
Combo Box
widget from the tool box into design panel and resize into your required size. You can find the widget in tool box by search
.Data Source
button in the configuration panel.CREATE NEW
button to launch a new connection from the connection type panel.Microsoft Excel
Connection type is selected for demonstration) of the listed connection type button shown.NEW DATA SOURCE
configuration panel, fill the connection type and related details. Click the Preview & Connect
button.Save
button.Properties
button in the configuration panel, property pane opens.ASSIGN DATA
tab.ASSIGN DATA
tab will be opened with the available measures and dimensions from the connected data source.You can add the Measures
or Dimensions
to the Columns
section by dragging and dropping the required column.
Define the Sort
of the dropped column through the Sort option in the Settings dropdown menu. For more details, refer to the Sort.
Define filter criteria through the Filter(s)
menu item in the Settings
drop down menu. For more details, refer to the filter.
Clear the filters by selecting the Show All Records
in the Settings
dropdown menu.
Click the Settings
icon in the dropped date value and select Relative Dates
in the drop-down menu.
In the launched Relative Date Options
window, configure the relative date and click Add. Repeat this process till the required set of relative dates are added.
You can see the added relative dates in the combo box as follows.
Note: If Multi selection is enabled, then the applied relative dates will be removed.
Click the Settings
icon in the dropped date value and select Relative Dates
in the drop-down menu.
In the launched Relative Date Options
window, select the Custom
option from the drop-down list.
Choose the start and end dates you like to set as custom range, set a name for the custom range, and then click Add.
Repeat this process till the required set of custom relative dates are added.
You can see the added custom relative dates in the combo box as follows.
Note: If Multi selection is enabled, then the applied relative dates will be removed.
You can format the combo box for a better illustration of the view that you require through the settings available in the Properties
tab. This pane can be opened from the design view by clicking the Settings
icon at the top right corner of the widget.
This allows you to set the title
for this combo box widget.
This allows you to set the subtitle
for this combo box widget.
This allows you to set the brief explanation about this combo box widget.
Enable Multi-Select
allows you to select the one or more items in the dropdown list.
You can able to select the multiple items in the combo box.
All - This allows you to select or unselect all the items in the combo box.
This allows you to enable a filter
box for easy filtering of data.
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.
This allows you to define this combo box widget to ignore responding to the filter actions applied on other widgets in dashboard.
Using this option, you can enable or disable hierarchical top N filtering. While applying the Top N filter with multiple dimension columns, the data returned can be customized based on whether the filtering needs to be done as flat or based on the hierarchy of dimension columns added.
When Enable Hierarchical Filtering
is enabled, the Top N will be applied for each individual column separately based on the number set for each column.
This allows you to handle the alignment of widget title to either left, center, or right.
This allows you to apply the text color
to the widget title.
On enabling Auto Font Size, the font size of the title will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Title Auto Font Size is disabled. Value can be between 10 and 44.
On enabling Auto Font Size, the font size of the subtitle will be adjusted automatically if the resolution of the screen varies.
Font Size
This allows you to apply the specified size of the font to the widget title if the Subtitle Auto Font Size is disabled. Value can be between 10 and 32.
This allows you to toggle the visibility of the border
surrounding the widget.
This allows you to apply the specified radius
to the widget corners if the Show Border is enabled. Value can be between 0 and 10.
This allows you to set the background color to the combo box widget.
This property allows you to specifies the transparency for the background color
.
This allows you to toggle the visibility of shadow
surrounding the widget.
This allows you to enable or disable the widget title
of the combo box widget.
This allows you to enable or disable comment
for the dashboard widget. For more details, refer to this link.