Do I need to make the average of the 3 values below (previous months) for the customer ID, any suggestions?
Moving Average.xlsx (1.9 MB)
can try the moving aggregator node.
rgds.
2 Likes
Hello @glaysontkd
You can test with ‘Column Expressions’ node:
average(
column("Consumption", 1)
, column("Consumption", 2)
, column("Consumption", 3)
)
BR
3 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.