How can I calculate a window average?

Hi all!

I have one column with date and hour (2016-01-01T00:00:00) and another column with website sessions.

How can I calculate a window average by day of week, hour?


I've found the MOVING AGREGATION NODE but didn't find more details of this node.

Is it what I need?

Hi Fabio,

this is not directly possible. You can extract the day of week beforehand, calculate the average using the groupby and than join it back to the original data.

Best wishes, IrisĀ 

Thank you!