Moving Aggregation over n-period window

I have this time series of several products. Each product has id number. Each row is id + date.
I need to perform Moving Aggregation over n-period window for each product, where the n value is a parameter.
I can sort the records and do the moving aggregation, but the window value needs to be a different parameter (variable) for each product.
Any clue if I can do this in the Moving Aggregation node or should I go the Lag + GroupBy + Join way?

Hi @deicide_bg

Did you check the Window Loop Start node? And use the Window Loop Start within GroupLoop start/end flow?
gr. Hans

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.