All Collections
How to...
Tools
Working with filters
Working with filters

Set up, disable and reset filters. Multi-select, single-select and histogram filter.

Barbora Hinnerova avatar
Written by Barbora Hinnerova
Updated over a week ago

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

Types of filters

CleverMaps supports several types of filters that enables you to filter data according to numeric, categorical, metrics data or dates.

In this article we will describe quantitative and qualitative filters. To filter your data by date, refer to Global date article.

Quantitative histogram filter

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 histogram filter offers these tools to work with:

  • Reset - resets the filter into its 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.

Intervals in quantitative histogram filter

Intervals in the quantitative histogram filter are always closed. It means that 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 multi-select filter

The qualitative multi-select filter works with categorical data. For example types of stores, price range categories, or days of the week. Control it by selecting item(s) from the list.
​
While no item is being selected, there are no data filtered out by the filter, hence all data are passed to the dashboard and map.
​


Qualitative multi-select filter offers these tools to work with:

  • Exclude - select all rows except the current one

  • Only - select only one row of data items

  • Reset - resets the filter into its 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 - select all rows in the list or none.

  • Search - this allows you to search through large lists. The search tool is available for 10 or more rows of data items.

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

Qualitative single-select filter

The qualitative single-select filter works with categorical data too. For example types of stores, price range categories, or days in the week. The difference between the multi-select and the single-select qualitative filter is that a single-select filter allows you to select only one item from the list.

Qualitative single-select filter offers these tools to work with:

  • Reset - resets the filter into its default setting.

  • Search - this allows you to search through large lists. The search tool is available for 10 and more rows of data items.

Filters conditions

  • If you select more items in the qualitative multi-select filter there's OR condition between the selected items.

  • If you set more than one filter (even of the same kind) there's AND condition between the active filters.
    ​

Managing your filters

Recognize active filters

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

The currently active filters are blue and stacked on top of the filter's panel.

Order of the filters matters

Filters are displayed and applied in the order they were added, meaning filters on a higher level apply to the ones beneath them. This rule applies to indicator filters.

New filters are always appended to the active ones.

To change filters order click on the arrows on the left side.

The only exception are data permission filters that are applied always first and their order cannot be changed.

Added filters whose value has not been changed are removed from the active panel when closed.

Reset filters

To reset all filters click on the arrow icon..

..or reset the filters directly from a map.

Get back to the dashboard

To close the filter panel and keep the setting of filter(s) click the "ok" icon.

To get back to the dashboard from filter panel click the cross icon.
​

Filters are categorized

Filters are categorized in the panel according to their connection to tables in the data model. It helps you to understand what portion of data will be affected by the settings of specific filters.

What's next?

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

Did this answer your question?