Hello everyone,
I am currently trying to compute the average of a historian Tag but only when another (boolean) Tag is on value 1.
To answer this problem, i thought about doing an Expression Tag which would keep my Tag’s value if boolean is 1 and be null otherwise. Unfortunately, this seems to compute the average with null values being considered as zeros.
Is there a way to keep only strictly positive samples of a historian Tag (and more generally keep only certain samples of a historian Tag on a condition) ?
Thank you kindly for your help,
Thank you for your answer.
Transaction groups seem indeed the way to go ! Unfortunately, they do not appear in my Ignition Designer Window. I am running on Ignition 7.9.4. Does anyone know why ?

Do you have the SQL Bridge Module?
1 Like
SQL Bridge Module can’t be selected or activated on my Gateway as you can see on this picture :
For information, Modbus Driver, OPC-UA, Siemens Drivers, Tag Historian, UDP and TCP Drivers, User Manual and Vision modules are activated, and all the others are running (2 hours trial that i can reset).
There is probably something simple that i am misssing but i cannot figure what it is…
How is it that i cannot download the module from the Gateway ?
Unfortunately the file cannot be opened…
Try going here:
https://inductiveautomation.com/downloads/archive
Select your version, then scroll down to find the SQL Bridge module.
I figured it out, thank you very much for your help !