🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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

User: "puhoma"
New Altair Community Member
Updated by Jocelyn
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.

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "puhoma"
    New Altair Community Member
    OP
    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).
    Hi,
    i think Process Windows is the solution for it.
    Best,
    Martin