Filters are pretty useful to keep and display only the rows that you care about. They lets you define rules to ignore rows.
Examples:
You will find the filters in the bottom part of “Chart data”
Filter rows in the Data Jumbo editor UI
The filters aims to hide rows, each rule will define which ones to hide.
Pick a column to be used as filter.
<aside> ☝ Its type matters, you won’t have access to the same filters depending on it. For example, only column of type number or formula can be filter by “is over”. Learn more about types here → Deal with Column types (Property)
</aside>
Pick a filter
| Filter name | Description |
|---|---|
| is empty | cell empty |
| is not empty | cell has a value |
| is equal to | cell is equal to an exact parameter |
| is not equal to | cell is anything but a parameter |
| contains | does the value contain the parameter |
| does not contain | does the value not contain the parameter |
| is over | strictly over a specified parameter (only for quantitative types) |
| is under | strictly under a specified parameter (only for quantitative types) |
| is before | if a date is before the parameter (only for date type) |
| is after | if a date is before the parameter (only for date type) |
| is … days before | if a date is N days before today - N as parameter (only for date type) |
| is … days after | if a date is N days after today - N as parameter (only for date type) |
| is not current… | if a date during the current day, week, month or year |
Last be not least, define the parameter of the filter. It will be necessary for all filters but is empty or is not empty
<aside> 📌 Applying a filter lets keep ALL rows but the ones that matches the filter. For example:
| Column value | Filter | Parameter | ⇒ Result |
|---|---|---|---|
| 10, 34, 12 | is over | 20 | 10, 12 |
| tomato, peas, chickpeas | contains | peas | tomato |
| 8 Oct 2021, 10 Dec 2021 | is before | 1 Dec 2021 | 10 Dec 2021 |
| </aside> |