How Data Sets Interact with Filters

There are several ways that data sets can interact with filters in a project. For example, filters might interact differently with visualizations depending on the number of data sets, whether the data sets are joined, and what the filters are applied to.

Various factors affect the interaction of data sets and filters in projects:

  • The number of data sets within a project.

  • The data sets that are joined (connected) or not-joined (for a project with multiple data sets).

  • The data elements (columns) that are matched between joined data sets.

You can use the Data Diagram in the Prepare canvas of a project to:

  • See joined and not-joined data sets.

  • Join or connect multiple data sets by matching the data elements in the data sets.

  • Disconnect the data sets by removing matched data elements.