I am storing the monitored information in a database. The data is stored every minute in the database. Right now the communication is configured to send the last state of the tags and store it. Here is my question:
What I want to do is instead of storing the data every minute by using the "Send last state" I would prefer to "Send every state" over a period of 1 minute and then store the average of those states for each tag and store this average value in the database. This would help me reduce the error in calculation.
Does the "Smoothing" property of the tags (interger/real) help me in any way to accomplish this task or you would suggest anything else?
Just to be clear "I need to store the average value of a tag over a period of 1 minute into the database?"
I can understand that a script (if needed) will be an array storing the values over a minute and then computing the average but then those arrays will have to be configured for each tag thereby doubling the number of tags in the system. Am I right?
Please share your insight into the issue.
