On Quiver I can do rolling aggregates for 1 year 2 year returns using rolling window. How do I do month to date and year to date calculations on Quiver.
Because for month to date my rollign window changes everyday. for 17th Sep 2024 time point the rolling window is 17 days but for 16t hSep 2024 the rolling window is 16 days.
The way we resolve this pyspark is by addign month and year to the group by clause.
Hi sominya.bajpai, you may want to use a periodic aggregate instead of a rolling aggregate here. With the periodic aggregate, you can select a date to start the first period and a duration for each period. This way, if you are taking a monthly aggregate (for example), the last period representing the current month will just use the data that has occurred during that month.
thanks it sounds good but how do I cater for varying days in month and also for the current month (28 days past in the month) I dont see ‘Month’ in the drop down for Unit