Need array to hold data for Information Manager Calculations service
I am using PLC Connect to bring analyzer data in via modbus TCP/IP. I need to calculate a 24 hour rolling average for the data and believe using Information Manager server Calculation service is the only option to manipulate PLC Connect data. However I need to use an array so as to drop the first in value from the calculation when a new data point is captured. How can I access an array in 800xA that will persist between executions of the Calculation?
I think for rolling average calculation you can use functions of Data Direct in Excel reading samples from Basic History. So all you need is to define Log Configuration for each monitored value and to create excel with using Data Direct Average function over defined time interval. Sure you can find some Data Direct examples in AKS forum. If you need to use Calculations, try to use General properties aspect as a "external memory" for the Calculation. Other options could be reading/writing values to text files (aka last century style) or to use external database through ODBC.