0

Question on performing nested aggregations in the Calculation Engine

Hi all,

I’m trying to calculate a “mileage” value in Canary. 

Mileage = sum of the absolute difference between each 2-second RealPower value and the previous one, aggregated over a 5-minute window.

My question:

Is it possible to do this directly at the 5-minute interval in the calculation engine, without first creating a separate 2-second interval calculation? In other words, can Canary roll up the 2-second absolute differences into 5 minutes on the fly, or do I need to calculate and store the 2-second values first and then aggregate them?

I will have 20+ of these calculations and was trying to avoid 20 calculations at 2 second intervals. 

2 replies

null
    • smason
    • 2 wk ago
    • Reported - view

    Hi ,

    I don't think you could do this without having the prerequisite 2-sec calc.

      • srieger
      • 13 days ago
      • Reported - view

       Thanks Steve

Content aside

print this pagePrint this page
  • Status Answered
  • 13 days agoLast active
  • 2Replies
  • 14Views
  • 3 Following