🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉
Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.
Rolling average on date format
I have a time series dataset.
I am trying to calculate the average demand over two periods of time which are:
- The week we are in now(today -3 days and today +3 days) but for the previous 2 years.
If today is 26th of August 2019
I need to run calculations on the records:
between 23rd August 2018 and 29th August 2018
and between 23rd August 2017 and 29th August 2017
So this will retrieve the average of these 14 rows.
I have in mind how to execute this in SQL but not on RapidMiner