Moving Average for Only Most Recent Date

bballboy8 · October 31, 2019, 5:31am

I am currently using the moving average node to calculate the moving averages for each row in my dataset. Is there a way to only calculate the most recent date’s moving average? Performing it on the whole dataset takes quite some time when I don’t really need it.

armingrudd · October 31, 2019, 5:56am

Hi @bballboy8 and welcome back to KNIME Community,

You can use the Date&Time-based Row Filter node to select rows within your desired date and time window.

bballboy8 · October 31, 2019, 5:57am

I still need the other rows in order to calculate the moving average though.

armingrudd · October 31, 2019, 6:05am

Excuse me, I think I cannot get it. You need to calculate the moving average of all the rows AND you do not want to calculate the moving average of rows other than recent date? What do you mean?

bballboy8 · October 31, 2019, 6:35am

I only need to calculate the moving average of the most recent date, but in order to do this, I need the other rows to perform the necessary calculations.

armingrudd · October 31, 2019, 7:15am

So what is your issue then?

ipazin · October 31, 2019, 10:46am

Hi there @bballboy8,

I guess you have a big window length? Some example could help though

Br,
Ivan

system · April 30, 2020, 10:46pm

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