Rolling average on date format

hk_

Hello

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.

For example:
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 
Please help!

MartinLiebig

Hi,

the operator you want to use is called Process Series and inside you may want to use a Extract Aggregates. The tutorial processes should be very telling.

Cheers,

Martin