I’m storing a level using the History property of the tag. I would like to develop a report that returns the avg, min and max grouped by hour for a given begin and end time. Seems like there are a few ways to accomplish this and I was wondering what is best practice.
What is the best option to bind the report dataset to? Tag History, DB Browse, SQL Query?
Where would the grouping/aggregation take place? In the query loading the dataset or in the report itself?
Currently my archiving strategy is using the automatic table design and default settings where every month a new table is created with the tagid, floatvalue, t_stamp, etc columns. I would prefer to get the data without having to write any SQL, but open to whatever is recommended.
Thanks for any advice