I have a water system customer with a flowmeter we read remotely and get the totalizer data about every 15 seconds. He asked me if I could make a table with hourly usage and perhaps daily as well. I was able to add a page with a power table and a date range along with a multistate button that switches the interval between hours and days and that all works fine to show the totalizer value at those intervals. I do not know how to calculate the difference between adjacent rows in the totalizer column and show that result in the next column. I will mark up a picture to help explain.
(In this screenshot, ignore my experimental numbers in the 3rd column that are in error. Also ignore the fact that the totalizer is counting backwards. The vendor of the meter says they have to physically turn it around to reverse the flow direction, so that should be fixed tomorrow).
