Cumulative Sum

KNIME Analytics Platform
1

Hi,
What would be the best way to get the cumulative sum of the Seconds Column based on the Group Column. (see sample data below). Please take note that the cumulative sum resets when followed by different group. Thanks!

image

2

Hi @mmrcs,
just for understanding. In your example the column group has 2 times the value 1. Are these data independent on from each other? If yes do you have other key columns there they differ?

BR

3

Hi @morpheus
Yes it occurred twice… they are independent from each other. I don’t have any other key columns where they differ, that’s why I’m having a hard time.

BR

1 Like
4

@mmrcs, I think I’ve solved it. I created the following workflow that will start a new running total/cumulative sum every time the group is different from the previous row.

Cumulative_Sum.knwf (28.3 KB)

Steve

5 Likes
5

Thanks for the help @stevelp
It really solves my problem!

BR

1 Like
6

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