Use interactive filters in dashboards

You can use interactive filters for charts and tables if the relevant filter conditions have been defined for these widgets. You can set a filter by clicking a data element of a widget, for example, a data point in a line chart. The selected data element of this widget takes effect as a filter for all associated widgets.

Multiple selection

Some widgets allow you to select multiple values at the same time to filter other widgets. You can select, for example, multiple rows in a table or multiple data points in a chart. Multiple selection is available if the corresponding Multiple selection option is enabled for a widget. The widgets providing the Multiple selection option are Column chart, Bar chart, Pie chart, Grid, and List. The widget to be filtered must also support multiple selection. For details, see the chapter Define filters for widgets.

Distribution charts

In distribution charts, you can select multiple values using a selection frame by default. If you select a range of values using a selection frame, the upper end of the rage is not included in the selection for filtering. For example, if you select a range from 10 to 20 and the step width is 1, the affected widget is filtered with the values 10 to 19.

Procedure

  1. Open a dashboard in view mode.

  2. Click a data element of a widget, for example, a coordinate of a line chart or a cell in a table.

    The selected data element is applied as a filter to all associated widgets.

  3. In distribution charts, you can use a selection frame to select multiple columns.

    1. Click a column and drag the mouse to the left or right.

    2. A selection frame is displayed.

    3. Release the mouse pointer.

      The selected columns are highlighted.

  4. Click the Show menu Menu icon > Clear selection to clear your filter settings. In charts, you can also click in the background of a widget to cancel the selection of your filter. The menu is available if the Show menu option is enabled for the widget.

The widgets are displayed with the filters selected.

You can define filters for specific widgets. See the chapter Define filters for widgets.