Hi there,

I have a triggered transaction group that stores the last 60 minutes of data from a machine (purges data older than an hour). I’d like to take this data and calculate the mean continually as the table updates. What’s the best way to go about this? I’m assuming I need to query the database at a set rate, put that data somewhere, and use the “mean” expression? Seems that the mean expression expects a table column though, correct? I can’t seem to figure out how to get the table to work with this…

Any better ways of doing this? I’m a newbie to Ignition and SQL, so I wouldn’t be surprised if I was approaching this incorrectly

Thanks!

Adam