0

Change Timestamp in Calculation

Forum / Questions & Answers

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.

2 replies

null
    • smason
    • 11 mths ago
    • Reported - view

    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,

      • rodrigopoyanco
      • 11 mths ago
      • Reported - view

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

Login to reply

Content aside

print this pagePrint this page
  • 11 mths agoLast active
  • 2Replies
  • 79Views
  • 2 Following