Add filters

Filters reduce the amount of data available in a dataset and help focus only on relevant data. A subset of data is automatically created based on your exclusions or inclusions. Filters apply to any data source (file or database).

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 a specific value

The following operators are available depending on the data type:

Prerequisites
  • You are creating or editing a dataset.
  • The Step 2 – Refine page or Step 3 – Join and preview is open.
Procedure
  1. Depending on the context, do one of the following:

    • If you are in Step 2 – Refine, select the needed data source, and then click Filters in the upper-right corner of the page.

    • If you are in Step 3 – Join and preview, next to the data source name, click More options and then Filters.

    The Filters dialog appears.

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

  3. 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.

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

  5. Click Apply.

    The filter is applied to the dataset.

    In Step 2 – Refine, a filter icon appears in the header of the filtered columns. To edit the filter, click Filters or a filter icon in front of a column name.

    To edit the filter in Step 3 – Join and preview, next to the data source name, click More options, and then Filters.

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

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