0
Question on performing nested aggregations in the Calculation Engine
Forum / Questions & Answers
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
-
Hi ,
I don't think you could do this without having the prerequisite 2-sec calc.