Fill down rows based on current row value within a group

[steve87]

Hello,

I have a workflow and data set is currently looking like this

I would like to have column prt_7d_used_count for each prt_7d_used_flag=1 summing the previous rows within the same parent_part. Final data set should look like this

Other solution would be to to fill down 0 with 1 where wrong_flag=1 within the same parent_part

[kat · Accepted solution]

Hi @steve87

Think this should do it:

 

Cheers

Kat

[steve87]

Thank you kat! This worked :)

[SamDesk]

Hello @steve87,

Another solution I've found to produce your desired outcome is to split the data in a filter using:

prt_7d_used_flag = 1

...before making the running count and then simpling unioning the data back together again.

Sam :)

[steve87]

Thank you @SamDesk but solution @kat provided starts counting from 1 where flag is set to 1 which is exactly what i was looking for