Combine AND and OR conditions for a value-based search
A value-based search allows you to combine multiple conditions using AND or OR, but not a combination of both.
In this example, we are interested in the periods during which the ALPHA or BETA products were produced and the temperature was higher than 80°C.
This method is only applicable with digital tags.
Perform a value-based search to find, for example, 2 different products in combination with another specified search criterion (here: temperature).
 |  |
Start a new value-based search with only one condition.
Start a new value-based search with an OR condition.
Start a new value-based search with an OR condition.
 |  |  |
Create a new formula to combine AND and OR conditions.
Formula:
if(and(or(product="ALPHA", product="BETA"), temp>80), 1, 0)
Variable mapping:
product = Product tag
temp = Temperature tag
 |  |