Static filters

ChartFactor Studio allows you to add and remove filters to your application by interacting with its widgets. This filters show on the Interaction Manager section.

In some cases, however, you may need to set static filters to a specific visualization so that they are not modified by any action.

One user case is when you want to exclude permanently a value from a specific visual (e.g. a null value) and you want users to be able to select the remaining values to filter the application.

A second use case is when you want to statically filter a chart by specific values. For example, you may want your bar chart to only show streets of a specific zipcode even when users select a differnt zipcode for the rest of the application.

Let's explore these two cases in detail

Excluding a value from a visual

In the figure below, the "Top Street Names" bar chart shows a bar with Null which means that no street was provided. We are going to permanently exclude this bar from the chart while allowing users to select the other bars to filter the application by those values.

1. Select the bar with the Null value

   

2. Change the filter operation to NOT IN in the Interaction Manager area by selecting the operation chicklet.

   

3. Next we want this filter to always stay in the bar chart even after we remove it from the Interaction Manager. For that, open the widget menu and select Static filters

   

4. Now, apply the static filter to this chart by selecting the Save button as shown below.

   

   The filter is now in the Static filters section of this visualization. Notice the "allow other filter values with different operations" checkbox is checked.

   

5. You can now close the Static filters dialog by selecting the "X" at the top right. And that's all. You can now remove the NOT IN filter from the Interaction Manager and all charts in the application will also include data when the Street name is Null except for the bar chart. The bar chart will never include a bar for the "Null" Street name.

   

   And users can select streets in the bar chart to filter the application by those street names as usual.

Statically filtering a chart by specific values

In the figure below, we have applied INCIDENT_ZIP with values 78702, 78704, and 78745 as a static filter on the "Top Street Names" bar chart. The rest of the charts in the application are filtered by INCIDENT_ZIP 78613.

Users may remove INCIDENT_ZIP 78613 and apply other zipcodes using the Interaction Manager. However, the "Top Street Names" bar chart would not be affected as it already has a static filter with different values applied.

The process of adding to and removing static filters from a chart is the same as the one explained in the Excluding a value from a visual section