Add a filter to a Model

You can add filters to a Model to limit the data it contains. This is useful when you have underlying tables that store more data than is necessary for the types of analyses the Model is intended for. You can also use Model filters to provide data security, when you want different groups of users to be able to see different data without relying on row-level security.

To add a filter to a Model:

  1. Select Data in the top menu bar, find your Model, and select its name.

  2. Select the Edit model button.

    Edit a Model
  3. Select Filters from the top menu.

    Add a Model filter
  4. Click Add filter. The Add filter window appears.

  5. Choose the column you want to filter on. If you choose a measure column, you can choose to set the filter as greater than, greater than or equal to, less than, less than or equal to, between, between (excluded), between (include Min), between (include Max), in, or not in, a numeric value or set of numeric values.

    If you choose an attribute column, you can choose to include or exclude a set of attribute values such as product names.

    If there are too many values, you can use the filter search bar to find the ones you want.

    Choose a Model column to filter on
    Specify values to include
  6. Select Add.

Progressive Model filters Beta

Previously, any filter defined at the Model level applied to every query based on that Model. Now, you can define which table a filter applies to in the Model TML. Once defined, the filter only applies to queries that include columns from that specific table.



Was this page helpful?