Access all your filters from the Filters panel in the toolbar:

Types of filters

Quantitative filters

These filters work with numeric data on a scale. For example number of orders, amount of dollars or minutes of delay. Control them by sliding breaks or clicking on breaks and inputting precise values.

Quantitative filters offer these tools to work with:

  • Reset - resets the filter into it's full range. This also means the filter becomes inactive as it does not filter any data.
  • Invert - inverts the current selection of the filter. Invert cannot be combined with the Zoom in/out tool.
  • Zoom in/out - Allows to zoom in on selected portion of the data for finer exploration. Zoom in/out cannot be combined with the Invert tool.

Intervals

Intervals in quantitative filters are always closed. It means that a it is a set of values between two endpoints A and B, where A and B are included. For example, the interval [56, 186] contains 56 and 186, as well as all numbers between them.

If you invert the setting you can get two half-opened intervals. Using previous example, it will operate as [0, 56) OR [186, 265>, where interval [56, 186] is not included.

Qualitative filters

These filters work with categorical data. For example types of stores, price range categories or days in the week. Control them by selecting categories from the list.

Qualitative filters offer these tools to work with:

  • Only - select only one row of data items
  • Reset - resets the filter into it's full range. This also means the filter becomes inactive as it does not filter any data.
  • Invert - inverts the current selection of the filter.
  • Select all/none - selects all rows in the list, or none.
  • Gather - pins all selected rows to the top of the list. Gather tool is available for 10 and more rows of data items.
  • Search - allows to search through large lists. Search tool is available for 10 and more rows of data items.

In this type of filter there can be maximum of 20 000 rows of data items.

Managing your filters

The blue counter icon informs you of the number of currently active filters.

To disable active filter without resetting its values:

  1. Hover the filter
  2. Click the eye icon

To reset all filters click on the arrow icon, to close filters panel and keep setting click the cross icon.

Filters conditions

If you select more options in qualitative filter there's OR condition between the selected options. If you set more than one filter there's AND condition between the active filters.

Filtering by time

To filter your data by time, refer to Global date.

What's next?

Read about advanced filtering using indicator filters.
Find out how to filter data just for specific object.

Did this answer your question?