Stacked Bar Filter

Description

This filter control is commonly used to filter datasets based on two specific fields identified in the Filter properties. This filter has a two-tier structure. Both are fields of the same dataset but are not related to each other (i.e. selecting one value does not affect the available options of the other). Only one value at a time can be set for each of the two fields.

This is suitable for string-type fields (field identified for Filter). This can be used as a simple filter on most views but is more useful as a hidden control used with the bar chart’s Select to Control property, which enables more interaction between views (i.e. selecting a bar on a stacked bar chart controls the displayed records on a Linear Table on the same page).

Viewer Usage

There are two tiers on the filter: - first tier - second tier

The data displayed are actually filtered by the two field values.

To use as a simple filter, simply set either or both field values.

Control Mechanism Usage

To use as a mechanism that allows a selecting a bar on a bar chart to control the data displayed on another view, both views must have relatable datasets. This means that both datasets used on both views must at least have the same two fields and data types.

Below is an example. Create a bar chart as in the screenshot below.

Set the Stacked Bar Filter control by selecting the bar chart’s Group By field as “Field #1”. Set the bar chart’s X field as “Field #2”.

Add the created Stacked Bar Filter control to the bar chart view’s Select to Control property.

Next create a linear table using the same dataset. Add the Stacked Bar Filter control to the Linear Table’s Controlled By property.

In this example, the selection on the bar chart view controls the displayed records on the linear table view. If exactly the same dataset is used on both bar chart and linear table views, the latter would effectively display all records that are aggregated into the selected bar.

Once all are set up properly, the bar chart and line table shows all the records in the dataset.

Click on any bar on the bar chart view. The displayed records on the linear table displays only the records for the selected bar.

In this case, the bar for gender “F” and education_level “Partial High School” are selected. This is also reflected on the bar chart view’s title as shown above. It appends the title given to the view, if any.

If the Stacked Bar Filter control is displayed on the control panel, the fields also reflect the selected bar’s values.

Specific Properties

Below are the fields that are specific to this control:

Field Description Mandatory Input Type Constraints Default Value
Group Dataset field used to group the values of the field selected in the “Filter” property. 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”
Initial Values (first) Determines the initial set or selected values upon loading in the Dashboard Viewer. This corresponds to the field selected for the “Filter #1” property. 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)
“None”
Initial Values (second) Determines the initial set or selected values upon loading in the Dashboard Viewer. This corresponds to the field selected for the “Filter #2” property. 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)
“None”