I have 2 Columns.
First Column is the Date.
The second Column has a value.
I want to see for each Day in the first Column the sum of the last 7 Days.
How can i do that in FME?
Solved
Sum of last 7 Days from Day X
Best answer by nielsgerrits
AttributeCreator, click Advanced, check "Enable Adjacent Feature Attributes" and set "Number of Prior Features" at 7.
Create a new attribute "result" with the value
@sum(@Value(B),@Value(feature[-1].B),,@Value(feature[-2].B),@Value(feature[-3].B),@Value(feature[-4].B),@Value(feature[-5].B),@Value(feature[-6].B))
+54- Best Answer
AttributeCreator, click Advanced, check "Enable Adjacent Feature Attributes" and set "Number of Prior Features" at 7.
Create a new attribute "result" with the value
@sum(@Value(B),@Value(feature[-1].B),,@Value(feature[-2].B),@Value(feature[-3].B),@Value(feature[-4].B),@Value(feature[-5].B),@Value(feature[-6].B))
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.