I’d appreciate anyone to point me in the right direction.
I am using Ignition 8.1. I have configured a flow totalizer tag that is logging to the tag historian (MSSQL) upon every change. I want to create a weekly report, i.e. 7 columns (Mon-Sun), that displays the;
a. Starting (min) volume and
b. Ending (max) volume and finally
c. Total volume (b-a) volume of that day.
As I’m new to Ignition reporting, I assume I should be using the “Tag Historian Query” as query type instead of the SQL Query as I would have to query multiple history tables (currently partitioned per month).
Any assistance on how I can achieve the above would be appreciated.