Aggregated Row Values (rolling sum so to say)

Hey everyone,

I feel that the solution is right around the corner :wink: however, I just can’t find it.

I have a table that looks like this:

image

I want to have something like a rolling aggregation. Something like this:

Row 0: 28 (28)
Row 1: 43 (28+15)
Row 2: 73 (28+15+30)

etc.

What I basically want to “mimic” here is finding a threshold. Where have I reached an 80% (or whatever percentage) threshold of the total values (I have a second stream in the workflow, where I calc the sum).

In Excel I would have gone by a formula like this…
image
… starting in the 2nd row…

I tried moving aggregation but couldn’t get it to work and also have the problem, that the window may change dynamically, because the base table (see first picture) may be larger or smaller every month.

Thank you in advance! :slight_smile:

I think I got your desired output with those settings:

6 Likes

I guess I have not read the node description thoroughly enough (that’s the lazy part in me :smiley: )

THANK YOU @tbtt :slight_smile:

1 Like

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