Creating selectable filters

Create selectable filters when you want to give users the choice of applying the filters in dashboards, reports, explorations, and so on.

The filters suggest possible options to filter data in the data module, but the users can also view unfiltered data.

About this task

Selectable filters can be created inside a table or outside a table (at the root of the data module).

Note: You cannot insert data module tables that contain both columns and filters into the report. A warning Unable to insert an object in the selected location will be displayed. Instead, select the columns and add them to the report, then select the filters and add them to the report.

Procedure

  1. Open a data module and decide what type of a selectable filter you want to create.
    • To create a filter inside a table, from the table context menu Vertical actions menu icon, click Filter.

      The Filter option is also available for a folder inside the table, and for the table in the diagram.

    • To create a filter outside a table, from the data module context menu Vertical actions menu icon, click Filter.

      The Filter option is also available for a folder at the root of the data module.

    The expression editor is displayed.
  2. Type the filter name.
  3. In the Expression panel, provide the filter expression by using the expression editor capabilities.
  4. Click OK

Results

The filter is added as a stand-alone entry in the data module tree with the filter icon Filter icon before the filter name. Filters created at the folder-level are added to the applicable folder.

What to do next

To edit the filter, from the filter context menu Vertical actions menu icon, click Edit filter. To remove the filter, from the filter context menu Vertical actions menu icon, click Remove.