Weighted Moving Average based on a time window

Hi,
I need to calculate the centered WMA based on a constant time window of 5 minutes. The problem I have is that there´s no periodicity in the input data and there´s more than one event per minute, so I can´t simply choose the last and next 5 cells.

image

Welcome to KNIME forum.
I can assume that you need binning. Create a bin table with necessary ranges (5 min).
Count number of events in every bin and calculate WMA.

Hi @pjacuna

I suggest to take a look at the Window Loop Start node. See this workflow mov_avg.knwf (33.9 KB)
moving_avg_time_window
Hope this helps
gr. Hans

2 Likes

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