FILTER Operation

How to use the Filter operation with Computed Attributes

Definition

Example

Syntax Guide

Formula In Use

 


Definition

The FILTER operation returns a list of items that achieve certain conditions.

 


Example

FILTER(GT($$ITEM, 2), [1, 2, 3, 4])

Result:
[3, 4]

 


Syntax Guide

FILTER(condition, range)

condition - An array formula evaluating to true or false

range - The data to be filtered

 


Formula In Use

filter-number


 

What's Next

 

If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

 

and please let us know 👇