6. Filtering data

Creating filters 

You can use filters to identify and isolate data based on some specific attribute.

Here's an example question:

How many of our customers have placed more than 6 orders?

To answer it, let's assume we have a nice 'ole customer table that contains this information, like so:



To find and isolate customers with more than 6 orders, we would simply:

  1. Click the header of the count_orders column.

  2. Select filter rows by count_orders.

  3. Add our filter i.e. > 6.

  4. Click save and you're done! Woohoo!


Depending on the type of data you're looking at, you can create different types of filters. For example, if you were looking at the Sales table and it contained the date on which each sale was made, you could create a filter to look at sales between two different dates (e.g. between the 1st March and 1st April), or on a rolling basis (e.g. within the last 7 days). If it contained the country in which each sale was made, you could create a filter to include, or exclude, specific countries.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.