I have the following table that cumulate value along the day by id and when the treshold (-150) is exceeded i need a flag and keep it until last.id ID value cumulative_value flag 1 35 35 0 1 35 70 0 1 100 170 0 1 -110 60 0 1 35 95 0 2 15 15 0 2 35 50 0 2 -130 -80 0 3 40 40 0 3 -125 -85 0 3 -90 -175 1 3 35 -140 1 3 35 -105 1 3 35 -70 1 I've tried a lot of lag and retains structures but it doesn't work.
... View more
