Hello,
I'm using the aggregate formula and I'm having hard time understanding Startkey() & middlekey(). Endkey() is very clear.
I used $s.aggregate(average(),periods(1year,1day),Endkey()) to calculate the yearly rolling avg and time stamp it at the end of each day.
I did the same thing for 6 month capsules $s.aggregate(average(),periods(1year,6month),Endkey()) and the end value of both data is equal.
When I use middlekey(): $s.aggregate(average(),periods(1year,6month),middlekey()) , I thought Seeq would calculate the middle value of the capsule meaning the last bar value on the graph below would calculate the average of 9/30/2018- 9/30/2019.
And for the startkey(), I thought the last bar value represents the beginning of the capsule rolling back 365 days. from 6/30/2018- 6/30/2019.
Please advice. Thanks