The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

calculate some statistics/aggregations for each date using a certain amount of previous dates

puhoma
puhoma Member Posts: 2 image Learner III
in Help
Hello. I have dataset with dates. I want to calculate some statistics/aggregations for each date using a certain amount of previous dates ( for example, to calculate for each day a sum of sales of 15 previous dates). What is the best way to do it. I know some clumsy ways, but think it could be better ones.

Answers

  • puhoma
    puhoma Member Posts: 2 image Learner III
    And I would like to use it not only with dates. Sometimes I need to calculate statistics using certain amount of previous raws  for each raw (that were sorted in a special way before).
  • MartinLiebig
    MartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 image RM Data Scientist
    Hi,
    i think Process Windows is the solution for it.
    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Categories