This section explains how dashboard filters work together with widget filters, and how you can configure different filtering behaviors and their effects on the dashboard.

The following procedures are explained below:

Configuring how Dashboard Filters Affect a Widget

Dashboard filters affect all the widgets in the dashboard, except widgets that you have defined to be independent. An independent widget is not affected by dashboard filters.

To make a widget filter-independent:

  1. Open (edit) this Widget in the Widget Designer, as described in Adding Widgets to a Dashboard. The top part of the WIDGET FILTERS panel on the right of the Widget Designer lists the Dashboard Filters that are defined for this Dashboard. widgetFilterDasbhoard
  2. Turn off the Dashboard filters that you do not want to affect this Widget: The toggle on icon on (default) indicates that the the Widget is affected by this Dashboard filter. The toggle off  off icon indicates that the widget is not affected by this Dashboard filter. You also have the option to make this Widget independent of all current and future Dashboard Widgets by turning the DASHBOARD FILTERS option off, as shown below:

widgetFilterDasbhoardOff

Defining how a widget behaves when filtered

When fields that are visible in a widget are filtered, it can be displayed in two ways – SLICE/FILTER or HIGHLIGHT. For example, let’s look at this column chart, which shows revenue for different age categories:

filterMode

If the chart is set to HIGHLIGHT mode, filtering a subset of age categories will highlight them in the chart:   filterModeHighlight

If the chart is set to SLICE/FILTER mode, the same filter will remove all non-selected age categories from the chart:   filterModeSlice

To define the filter behavior mode:

  • Select Slice/Filter or Highlight in the Filters panel on the right side of the dashboard.

slice dice new

Defining how a selection on the widget affects the dashboard

When making a selection on a widget, a filter is added to the dashboard with the selected part of the chart as the applied filter.

To disable this option for a widget, open the widget in editing mode, and from the menu options, disable Widget Affects Dashboard Filters.

widget affects