|
|
It is common practice, when calculating analytics from field sensors to leverage Min and Max to avoid miscalculations. For example, a sensor signal, when faulty, may become negative, while commonly having a positive value. To avoid this, a simple expression MAX (0, @sensor) will avoid calculation errors. The same applies for function MIN.
Another very useful way is defining MIN and MAX limits like sensor_out = max(0, min(100, @sensor). This simple expression sets calculation boundaries when using actual sensor data.
