OK, I’m a little stumped on how to accomplish this easily. I have two reports built in my project for flow totals.
The daily report need to have a row populate for each hour of the day at the top of the hour showing a snapshot of the tag values. At the bottom of the report, it needs to calculate the total of each column that day. I have the report built, and have it set to add the total at the bottom, but I can’t figure out an elegant way to build a query to populate the hourly readings.
Second, I have a monthly report where I need to populate a row each day with the total of the readings for each day. I would assume this could also be done with just a query?
I have tried this using tag history to fill in, and I also set up a transaction group, but neither worked quite right (missed readings, duplicate readings, late readings, etc.)
Any SQL Query gurus want to help a poor soul?