Filter elements represent a special type of dashboard item that allows you to apply filtering to other dashboard items.
Filter Elements Overview
The Web Dashboard allows you to create filter elements that used to filter other dashboard items.
To add the required filter element to the dashboard, use corresponding buttons into the Filter section of the Toolbox.
The Combo Box dashboard item allows you to select a value(s) from the drop-down list.
You can switch the combo box type in the Combo Box’s Options menu. The table below demonstrates available Combo Box’s types.
|The Standard type allows you to select only a single value.||The Checked type allows you to select multiple values in the invoked drop-down list.|
By default, the Combo Box’s dropdown contains an ‘All’ item that allows you to select/deselect all items in the Combo Box. To hide this item, turn off the Show ‘All’ Value option in the Combo Box’s Options menu.
The List Box dashboard item allows you to select a value(s) from the list.
You can switch the list box type in the List Box’s Options menu. The table below demonstrates available List Box’s types.
|The Checked type allows you to select multiple values in the list box.||The Radio type allows you to select only a single value in the radio group.|
The Tree View dashboard item displays values in a hierarchical way and allows you to expand/collapse nodes.
You can manage the initial expanded state of filter values using the Auto Expand option in the Tree View’s Options menu.
The Date Filter dashboard item allows you to filter dashboard data based on the selected data range.
See Date Filter for details.
The Web Dashboard allows you to bind various dashboard items to data in a consistent manner, the only difference being the data sections that these dashboard items comprise. To learn more about common binding concepts, see the Bind Dashboard Items to Data topic.
This topic describes how to bind filter elements to data using the Web Dashboard control.
All filter elements provide the Dimensions data section, which accepts dimensions used to provide filter values.
To bind the filter elements to data, click a placeholder contained in one of the available data sections and select the required data source field in the Binding section of the invoked data item menu.
To learn about the specifics of binding various filter elements to data, see the table below.
|Dashboard Item||Data Sections||Description|
|Combo Box||The Combo Box filter element can contain several dimensions at the Dimensions data section. In this case , the drop-down list will contain combinations of dimension values.|
|List Box||The List Box filter element can contain several dimensions at the Dimensions data section. In this case, the list will contain combinations of dimension values.|
|Tree View||The Tree View filter element can contain several dimensions at the Dimensions data section. In this case, dimension values are displayed in a hierarchical way. This can be the set of dimensions with different group intervals (e.g., Year/Quarter/Month) or the set of related dimensions (e.g., geographical data such as continents/countries/cities).|
This document describes filtering capabilities supported by filter elements. You can use filter elements to apply master filtering to other dashboard items or introduce hierarchical filtering by adding several connected filters.
The Dashboard allows you to use any data aware dashboard item as a filter for other dashboard items (Master Filter).
Note that filter elements do not support Master Filter selection modes. You can switch the selection mode by changing the type of the required filter element.
Depending on the filter element type, you can select a value(s) to make other dashboard items display only data related to the selected value(s).
You can also create a set of related filter elements containing relevant filter values. For instance, in the image below, the State filter element contains states related to the ‘United States’ value, while the City filter element contains cities related to the ‘New York’ value.
Disable the Ignore Master Filters option in the Interactivity menu for the required filter element to allow the applying of filtering to this element.