Skip to main content
  • EN

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?

Sum

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(featuree-2].B),@Value(featurer-3].B),@Value(featurer-4].B),@Value(featurer-5].B),@Value(featurer-6].B))

AttributeCreatorParameters

Reply


Community Stats

30,186
Posts
114,572
Replies
37,849
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.