In the Widget Designer, you can define a filter for the data in a widget. For example, you can create a filter that only shows the fields of relevant countries. The filters are not visible in the dashboard, nor can they be edited directly from the dashboard.

This section includes the following procedures:

Note about duplicate filtering: When creating a widget filter for a field that is already filtered in a dashboard filter, the widget filter will override the dashboard filter.
Example: You have a dashboard filter, filtering the months field, with the values January and February selected. At the same time you create a filter for a widget, also for months, but this time March and April are selected. When both filters are applied in the dashboard, you will see data for March and April in the widget, according to the widget’s filter.
If your widget is filtered using measured values, then the measured value will override any other widget or dashboard filters you have for the same fields.

Creating a Widget Filter

To add a widget filter:

  1. Open (edit) this Widget in the Widget Designer, as described in Adding Widgets to a Dashboard.
  2. Click the FILTERS tab in the widget designer.filterTab
  3. The FILTERS panel is displayed showing the filters defined for this Widget. Click on the ADD FILTER button to display the Data Browser, which lists the fields in the ElastiCube. A Data Browser is displayed.
    widgetFilterAdd
  4. Click on a field in the Data Browser to add it as a filter. You can define multiple filters, each for a different field. These filters have an AND relationship between them. Each filter that you define appears on the WIDGET FILTERS panel on the right enabling you to easily edit it if needed. The procedure for defining a Widget filter is similar to the procedure for defining a Dashboard filter, as described in Creating Dashboard Filters. The difference is that the widget filter only affects its hosting widget, and is accessible only via the widget designer, not directly from the dashboard.

Adding a Widget Filter to an Existing Field

Adding a new widget filter, as described above, lets you use any field as a widget filter. Sometimes you want to directly filter a field that is already part of the widget and visible in the data panel on the left.

To add a Widget Filter to an existing field:

  • Hover over the field you want to filter, and click the FILTER icon.