Add a filter to a table

You can add a simple filter from a column header while viewing your answer as a table.

The new filter selection modal is part of the new answer experience. The new answer experience is on by default. If you have the classic answer experience on, your user interface and experience may be different from the experience described in this article. You can turn the new answer experience on or off individually from the Experience manager panel in your profile. If that option is not available, contact your administrator.

To add a filter from column headers:

  1. While viewing your answer as a table, hover over the column header you want to filter, and select the More menu icon more options menu icon.

  2. Select Filter.

  3. The filter modals for attributes and measures are different. The modal for an attribute looks like this:

    Attribute filter modal

    The modal for a measure looks like this:

    Measure filter modal
  4. For an attribute filter, select values to include or exclude. You can also select all or clear all. If there are too many values, you can use the filter search bar to find the ones you want. The filter modal only shows 500 values; if the column you selected has more than 500 values, you must use the filter search bar to find the additional values.

  5. For a measure filter, select Add a condition. Choose an operator, such as is greater than, and enter a number. For example, to see under-performing stores, with sales under 10 million, select is less than or equal to and enter 10 million. To add another filter for that measure, select Add another.

  6. Select Done.

Was this page helpful?