Moving Aggregator

KNIME Analytics Platform
1

Hello,

I want to use Moving aggregator: Backward; Window L 3; Mean. But I don’t want the last row to be taken into account (by date).

Example : 4 ; 8 ; 12 ; 20

I get (4 + 8 + 12) / 3 but i want (8 + 12 + 20) /3

If you have any idea

Thanks

Br

2

Hi Brian,

for me its hard to follow. On one hand you don’t want to take the last into accound (your text) on the other hand you take the last row into the calculation.
Could you provide a more detailed example?

Andreas

3

What i want is to exclude th most recent value in moving agregator.

Ex : Last 20 ; 30 ; 25 ; 28 Moving aggregator = 27.7

Row => column A 20 column B 27.7

Imagine numbers are work hours / week => 20 hours last week => 3 weeks before average = 27.7. It means this week i work 7.7 hours less than the previous 3 weeks

4

How about shifting column B after the moving average?

A B C
20 ? ?
30 ? ?
25 (25+30+20)/3 ?
28 (28+25+30)/3 (25+30+20)/3