Datadirect Average Daily Flows
This should be an easy one but I'm pulling hair out.
I use datadirect to get information from 800xA history. I pull up a tag, enter a months worth in the range? Set the time to 00:00:00 for both. Select Average. And then select how many days are in the month for the count. Some months it is correct everything is sorted nicely days 1,2,3,4,5 ect and time stamp all 00:00:00. Sometimes I hit a month and for no explanation the time stamps start to float around. 04 then 010 then even back to 23:45 and so on. Some of the timestamps double for a day one at 00:05 and then the same day at 23:58...
Is there a better way to get average Monthly, Daily hourly data out??
The 800xA system provides a number of templates for reports contained in the Scheduling Structure. I have included a document that details how to configure and generate one of these reports that provides one hour averages of up to 20 data points per report, (you don't need to configure all 20 if they are not needed). Additionally, I have included a slightly modified version of this report and a sample of the output with only two variables configured.