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.
Procedure
-
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.
-
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.
-
Select the Country column.
This time, the data is displayed in the form of a world map. The more
occurrences of a country there is, the darkest this country will be on the
map.
You can alternate between the world map view and the usual bar chart view by
clicking the icons on the top right of the chart tab.
-
Click Brazil directly on the map to add this filter to the previous one.
The grid now only displays the data corresponding to those two filters.
-
In the Functions panel, click a function to execute it
on the data you filtered, Delete these Filtered Rows for
example.
-
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.