So I think I am having a brain fart, but this is what I would like to do within Ignition using datasets and tables and nothing comes to mind -
I want to take an hourly reading of a tank level (using tag history) - use that to get the volume of the tank in gallons and then subtract it from the previous reading to get the gallons consumed or added during the time interval.
At the moment nothing is coming to mind of how to do this in a somewhat straightforward fashion. I am hoping to use this data in a report.
I thought about doing a button that runs a script and populates another dataset and loops through the original table. I got stuck there because I couldn’t see how to pass the size of a dataset to the script.
I would use Transaction Groups to accomplish your task. You would use two transaction groups and two database tables. One transaction group would log the current value every hour to a database table, the second transaction group would run a query against that table and store the hourly deviation in a second table.