Change Timestamp in Calculation
Hello Everyone.
I would like to do some aggregation hour by hour (using ResettingAnchoredInterval and DeltaBounds) from a totalizer tag (an energy totalizer in MWh). The problem is that I trigger the calculation at 00:00 of each hour, and this store the value of the past hour with the timestamp of the current hour (I mean, at 09:00 AM, Canary save the result of the DeltaBound bewtween 08:00:00 and 08:59:59, but with the timestamp of 09:00:00).
Is there any way to save the TVQ of the calculation but with the timestamp of the previous hour? (In the example, save it with the timestamp of 08:00:00).
Thank you.
-
Hi rodrigopoyanco ,
You can do that with the "TS" (timestamp) box. If you want to output a timestamp an hour earlier you could do "now-1h" or "h-1h". See below,
-
Steve Mason Thank you so much, I didn't try it. Works perfect.
-
Print this page