Perform a cumulative sum per month/quarter/year

Hi, I have this raw data:

I want to create another column with the cumulative sum of the members per month/quarter/year, as example per month should be like this:

1,
3,
4,
6,
10,…etc.

Any suggestion? Thanks in advance.

Maybe something like this helps get you started, using the GroupBy node (with count aggregation) and the Moving Aggregation node (with cumulative option checked, and sum for aggregation).

Afterward I leave it to you to figure out how best to join the branches back together, if that’s needed.

2020-05-08 10_59_26-KNIME Analytics Platform

GroupedCumulativeSumExample.knwf (13.4 KB)

1 Like

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