OR function

You can filter your visualization based on multiple conditions without the use of formulas. Using the More Actions menu allows you to apply these actions directly in your visualization. See the More Actions article to learn how to use these actions with Series, Axes, and Hidden Data.

The Klipfolio OR function tests each value in a condition and performs the boolean operation or on the results.

The OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.

The syntax for the OR function is:

OR( condition )

Parameters

condition The value you want to test.  The result can be either true or false. vector

OR example

Let's look at an OR function example.

 

A

B

1 Apples 10
2 Pears 20
3 Peaches 30

The following example is based on the above text from an Excel spreadsheet:

SELECT( B:B , OR( ( A:A = "Pears" ) , ( A:A = "Peaches" )))  

-> [20, 30]

Related links: