๐ŸŽ‰ ๐ŸŽ‰ RAPIDMINER 9.10 BETA IS OUT!!! ๐ŸŽ‰๐ŸŽ‰

GRAB THE HOTTEST NEW BETA OF AI HUB/SERVER, STUDIO, AND RADOOP. LET US KNOW WHAT YOU THINK!

CLICK HERE TO DOWNLOAD

Rolling average on date format

hk_hk_ Member Posts: 1 Newbie
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!

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,042  RM Data Scientist
    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
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
    Tghadiallysgenzer
Sign In or Register to comment.