06-28-2013 11:13 PM
Can anyone recommend the best way to keep a 30 day rolling average of a single variable based on 1 hour averages? I am thinking about using Citadel with and SQL query to update the average. If there's a better way, I would appreaciate any ideas.
07-18-2013 12:55 PM
I think you are on the right path, use the existing Citadel information with ODBC & SQL to get the data.
Saves archiving "duplicate" data.
