Filters are pretty useful to keep and display only the rows that you care about. They lets you define rules to ignore rows.

Examples:

• Keep only the rows edited today or this last 3 days
• Remove the rows containing empty cells
• Use only rows that contains a specific value

How to create a filter?

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.

1. 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>

2. 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

3. 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:

Examples