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 )
|condition||The value you want to test. The result can be either true or false.||vector|
Let's look at an OR function example.
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]