0

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.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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,

    Like
    • Steve Mason Thank you so much, I didn't try it. Works perfect.

      Like
print this pagePrint this page
Like Follow
  • 8 mths agoLast active
  • 2Replies
  • 70Views
  • 2 Following