This filter control is commonly used to filter datasets based on one specific field identified in the
Filter property. The filter has the same effect on the data as using a [Gruoped Select Filter](grouped SelectFilter.html). The difference is in the user experience as there is a clear categorization of the options. This filter has a three-tier structure, using another dataset field as the root values to group the actual filter values.
This is best used if the filtered dataset field can be grouped using another dataset field that puts the former into mutually exclusive groups (i.e. all child options appear in only one root option). This is suitable for string-type fields (field identified for
Filter) with not so many options that also require only one value to be selected at a time.
There are three tiers on the filter: - Group Level 1 (or root) tier - Group Level 2 (or child) tier - Filter tier
Only the values on the Filter tier are actually being filtered. The available options on the Group 2 tier are dependent on the value selected on the Group 1 tier. Selecting a value for the Group 1 tier filters out all options in the Group 2 tier that do not fall under the group. For instance, if “MN” is not grouped under “South”, the user has to select “Midwest” as the Group 1 tier then subsequently select “MN” to be able to filter the data for this value.
Do note that this control only works if that are no duplicate values, i.e. you cannot have a city called Brooklyn Park in different states.
Below are the fields that are specific to this control:
|Field||Description||Mandatory||Input Type||Constraints||Default Value|
|Dataset||Name of the dataset that contains the data to be used as the control’s selector options.||Y||Select||One value can be selected. All enabled datasets are available options.||None|
|Subset||Subset of the dataset selected.||N||Select||One value can be selected. All enabled subsets of the selected dataset. The dataset must be selected first.||None|
|Group Level 1||Field of the selected dataset which would be used to first group the “Filter” field values.||Y||Select||One value can be selected. All fields of the selected dataset/subset combination. The dataset and subset (optional) must be selected first.||None|
|Group Level 2||Field of the selected dataset which would be used to group the “Filter” field values after Group Level 1.||Y||Select||One value can be selected. All fields of the selected dataset/subset combination. The dataset and subset (optional) must be selected first.||None|
|Filter||Field of the selected dataset which contains the values to be used as the control’s selector options.||Y||Select||One value can be selected. All fields of the selected dataset/subset combination. The dataset and subset (optional) must be selected first.||None|
|Group 1 Label||Name for Group Level 1 field.||Y||Textbox||Any Text.||None|
|Group 2 Label||Name for Group Level 2 field.||Y||Textbox||Any Text.||None|
|Filter Label||Name for Filter field.||Y||Textbox||Any Text.||None|
|Initial Values||Determines the initial set or selected values upon loading in the Dashboard Viewer. This corresponds to the field selected for the “Filter” property. This setting is applicable only for the second-tier options.||Y||Select||One value can be selected. Available options are:
- None (all options are deselected)
- First (only the first displayed option is selected)
- Last (only the last displayed option is selected)
- All (all of the options are selected)
- Values (first element of comma-separated values entered in the field that appears below this property; spaces are allowed before and after the comma)