How do I filter my query results?

To filter your query results:

1. Run your query and go to the visualization of your interest.
2. Click the ‘Filter’ icon at the top and then on ‘+Add Filter Rule’.
3. In the ‘Fields’ dropdown, choose the indicator you want to filter. This dropdown will have all the indicators you have initially chosen for your query.
4. Under the ‘I want to...’ box select ‘remove’.
5. From the next dropdown make a selection based on your required filtering. The options are:

a. Top: removes ‘x’ number of results with the highest values

b. Bottom: removes ‘x’ number of results with the lowest values

c. Above: removes values above ‘x’

d. Below: removes values below ‘x’

e. Above average: removes all values that are above the average of the value of your query

f. Below average: removes all values that are below the average of the value of your query

g. Values equal to zero: removes data points with zero (0) values

h. Values equal to null: removes data points with missing values

6. Some rules (e.g. top, bottom, above, below etc.) require a third input. In the third box, if prompted, enter the desired threshold for your filtering. For example, ‘I want to...remove (first dropdown) data points below (second dropdown) 1000 (third box).
7. Click ‘Apply Rules’ to save the changes.

You may use the ‘+Add Filter Rule’ and delete buttons to add or remove filtering conditions to your query. In this way, multiple filter rules can be applied sequentially.

Updated on: 24/09/2025