Converting a Condition to a Signal

[John Cox]

A common analytics need is to create a signal with numerical values that are based on an existing condition. Users often want to translate a condition (on/off, good data/bad data, running/down, etc.) to a numerical value to be used in calculations. For example, a user may want to multiply a process signal by a 0/1 value based on when the process is down/running. This technique can also be used to replicate "if" logic or "if / else" logic, where different values are returned depending on if the condition is true/false. 

Converting a condition to a signal value can be easily accomplished in Seeq using the Formula Tool and the splice function. Here is an example where we convert a condition to a signal of 0s and 1s:

 

1. Use the Value Search Tool to create a HOT condition for time periods when the Temperature signal is > 90 degrees F:

 

2. Use the Formula Tool to convert the HOT condition to a 1 (when condition is true) and a 0 (when condition is false):

 

3. View the results in the trend. The new signal in lane 2 has a value of 1 when the HOT condition is true. Otherwise the signal is 0.

 

Additional Information

Using Conditions and the Splice Function to Replace If Statements

 

 

Edited May 21, 2019 by John Cox
minor formatting issue