Filtering data using the Data in analysis flyout

In your analysis, you can filter to data in which you are particularly interested and filter out the rest. The filtering can be handled from the Data in analysis flyout.

For more information, see Filtering data.

Prerequisites

The Data in analysis flyout is open.

Procedure

  1. In the flyout, move the cursor over the column containing the values you want to filter out, and click Show filter .
    Note: If you are working with in-database tables, filters may not have been created. Then you need to first click Click to create a filter to make the filter available.
    The filter associated with the column opens. One type of filter is shown below.



  2. Use the opened filter to specify which column values to keep and which values to filter out.
  3. Repeat from step 2 to filter data in another column.
    Information about which columns have been filtered, and to which values, is available at the bottom of the panel. If you want to modify what has been filtered in a filter, you can open the filter also from there by simply clicking it.

    Note: Any filtering action in the Data in analysis flyout also updates the filters in the Filters panel.

Example

The data table below lists how much money each customer spent last time they visited a store. Also the customer's age and gender are registered.

What if you are interested in only showing purchases made by female customers between 40 and 50? Simply filter to these particular values using the Data in analysis flyout as shown below.

The data table, and every visualization based on it, will adjust to visualize only this limited part of the loaded data.