In industrial data analysis, it is often necessary to formulate complex conditions to achieve precise search results. However, it is not possible by default to combine AND and OR conditions within a value-based search in TrendMiner. TrendMiner allows you to combine multiple conditions in a value-based search, but you can only combine all conditions with either AND or all with OR—not both simultaneously. Here, I will show you how to effectively combine AND and OR conditions in a value-based search.

Examples of combining AND and OR conditions

A typical example would be searching for production data where multiple products (e.g., ALPHA and BETA) are analyzed under specific temperature conditions. Other examples include identifying production phases where certain machines are either in "Standby" or "Maintenance" mode, but only if energy consumption is below a defined threshold. Another example could be analyzing phases where specific chemicals are either in a "Mixing" or "Reaction" state, but only if the pressure exceeds a certain limit.

Methods for combining AND and OR conditions

Option A: Multiple states in one search condition

This method is applicable only to digital tags.

1. Perform a value-based search: Start a value-based search to look for, for example, two different products in combination with another specified search criterion (e.g., temperature).

Option B: Using filters

1. Start a new value-based search: Begin a new value-based search with only one condition.

   

    

2. Create a filter: Click on “Keep results” to filter the results.

   

    

3. Start a new value-based search: Perform another value-based search, this time with an OR condition, to broaden the search.

   

    

Option C: Using a formula tag

1. Create a formula: Create a new formula to combine AND and OR conditions, e.g., if(and(or(product="ALPHA",product="BETA"),temp>80),1,0). Here, product is the product tag, and temp is the temperature tag.

   

    

2. Perform a value-based search: Conduct a value-based search to identify the periods when the formula tag equals 1.

   

    

Benefit

These methods significantly enhance the functionality of value-based searches in TrendMiner, allowing for more complex queries to be conducted efficiently. By combining AND and OR conditions, you can achieve more precise and specific search results. This leads to better data analysis, optimizes process control, and supports informed decision-making. This ensures that even fleeting issues are detected, leading to more accurate insights and better-informed decisions for process optimization and troubleshooting.