Filter a Dataset Table

In most cases when you add a table to the dataset, all of the table's column values are included. You can add filters so that the table contains only the values needed in the dataset.

For information about using filters, see About Filters and Filter Types.

Applying a filter to a column limits everything in the table. For example, if a table contains data for every world region, you can create a filter on the COUNTRY_REGION column and set its value to Americas so that your table's columns contain data for North, Central, and South America.

If you add more than one filter to the dataset, by default the filters limit each other. For example, if you add a filter on the COUNTRY_REGION column and set its value to Americas and then add a filter on the COUNTRY column, the COUNTRY column's filter selection values are limited to the names of countries in the Americas, for example, Canada, Brazil, and Panama.

Any filters that you apply limit what is displayed in the table's quality tiles, the Transform editor, and the table's data preview.

You can create filters on columns that have been removed from the table. See Remove or Restore a Dataset Table's Columns.

In some cases you might want to use the table's filter to query other visualizations in a workbook. See Include a Dataset Table in Data Source Queries.

1. On the Home page, click Navigator and then click Data.
2. Click the Datasets tab.
3. Locate the dataset that you want to open, click Actions, and then click Open.
4. In the Join Diagram go to the Table Page Tabs and click the table that you want to work with.
5. In the Transform editor, click the Edit Definition button.
   
   
   Description of the illustration data_set_transform_edit_definition.jpg
   
   
6. Click Add Filter.
7. Select the column that you want to filter by.
   
   
   Description of the illustration data_set_editor_filter_select_02.jpg
   
   
8. Select the filter's values.
9. Click off the filter.