Add filters

Filters help focus only on relevant data. A subset of data is automatically created based on your exclusions or inclusions.

Depending on your needs, filters can include the following condition types:

  • Condition – One-line simple condition record. For example, you want to see all records for a specific year only.

  • Group – Multiple conditions related through an OR or AND operator. All the conditions in a group are evaluated before all the other conditions outside the group.

    For example, the following filter is made of two groups, each containing two conditions.

    • Rows with all the transactions after February 1st, 2014, where the cost of manufacturing was greater than a specific value
    • Rows with all the transactions before February 1st, 2014, where the cost of manufacturing was less than other specific value

The following operators are available depending on the data type:

  • does not equal
  • equals to
  • is between
  • is greater than
  • is greater than or equal to
  • is less than
  • is less or equal to
  • is not between
  • is not null
  • is null

  • contains
  • does not contain
  • does not end with
  • does not equal
  • does not start with
  • ends with
  • equals
  • is blank
  • is in list
  • is not blank
  • is not in list
  • starts with
  • is null
  • is not null

If your dataset contains user information, you can add user macros in filters. For details, see Functions & macros.

Procedure

  1. To add a filter to the data in a visualization, open its widget settings.

    To add a filter to the Filter or Highlighter widget, open it for editing (in the Filters or Highlighters pane).

  2. Next to the dataset, click filters.

    The Filters dialog appears.

  3. Depending on your needs, click one of the following:

    1. Click Condition to create an individual one-line filtering condition record.

      The condition record appears.

    2. From the first dropdown list, select a dimension or measure that you want to filter.

    3. Select the condition.

    4. Enter the value against which you want to filter.

      Depending on the condition type, you can click Display data values to select from the values available in the dataset.

      The search field is case-sensitive.

    If you want to add several conditions as a group, click Group.

    Click the empty group record that appears, and then add a condition. The condition is added within a group. Click inside the group, then add as many conditions as you need.

    You can also add a group in a group for even more complex conditions.

    Note: To add a condition that is not part of a group, click outside the group, and then click Condition. To add a group outside an existing group, just click outside that group, and then click Group.

  4. Add other conditions or groups of conditions.

    If you have several conditions or groups, check that all the And or Or operators are selected as needed.

  5. (Optional) To view the filters using the SQL syntax, click View SQL. Click Close to go back to filters conditions view.

  6. Click Apply.

    (Visualization) The filter is applied to the data shown in this visualization.

    (Filter and Highlighter) The filter is applied to the list of values for highlighting or filtering.

    A filter icon becomes blue after you define a filter.

    To delete a filter, you need to edit it and delete all its conditions.

    Important: Deletion is performed without confirmation and cannot be undone.