integral() is one of the only functions that violate one of our axioms: "queries should behave exactly the same way regardless of what window you are looking at" (the others being normalize() and...
See more...
integral() is one of the only functions that violate one of our axioms: "queries should behave exactly the same way regardless of what window you are looking at" (the others being normalize() and the upcoming holt-windows function). This is because integral sums from the left of the window until the right, accumulating as it goes. Hence the value at a particular time will change depending on when the window starts. Using msum(), for instance, makes it stable. Hope that helps.
