Skip to main content Skip to complementary content

Filtering values using charts

The Chart tab shows a graphical representation of your data. It is also a quick and easy way to apply filter on your data.

This example uses a dataset with typical customer information, such as their names, gender, email or the country they live in.

Dataset containing customer information.

Procedure

  1. Select a column containing text data you want to filter, First_Name for instance.

    The horizontal bar chart showing the most common occurrences of first names is displayed in the chart tab.

    Most common occurrences of first names displayed in the chart tab.
  2. Click the top bar to apply a filter on the most common first name.

    The preparation now only displays the rows with this first name.

    You can also use Ctrl + Click or Shift + Click to select multiple values at the same time and apply a more complex filter.

  3. Select the State column.

    This time, the data is displayed in the form of a US map. The more occurrences of a state there is, the darkest this state will be on the map.

    State distribution displayed in Chart tab.

    You can alternate between the US map view and the usual bar chart view by clicking the icons on the top right of the chart tab.

  4. Click California directly on the map to add this filter to the previous one.
    Filters applied.

    The grid now only displays the data corresponding to those two filters.

  5. In the Functions panel, click a function to execute it on the data you filtered, Delete these Filtered Rows for example.
  6. In the filter bar, click the cross in each individual filter or click the garbage bin icon to clear the filters and display the whole dataset again.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!