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.
In the flyout, move the cursor over the column containing the values you want to filter out, and click
The filter associated with the column opens. One type of filter is shown below.
- Use the opened filter to specify which column values to keep and which values to filter out.
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.
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.