How to count Flag changes?

[chr_pro]

Hi this might be a straightforward question but i cant seem to figure it out.

I would like to count the changes in the Column "Krit Tage" (consecutive 1 doesnt count)

In this example i would to add a "new" column that counts 3 changes in "Krit Tage".

Thanks in advance, looking forward to your reply.

[MarcoWedel]

Are you looking for a script solution or a table expression?

[chr_pro]

Hi Marco,

a table expression would be sufficient. Not sure if we need more information for a script solution 🙂

[sergio0592]

Hi,

Maybe you can try as calculated dimension :

=aggr(if((Krit Tage=1 and Above(Krit Tage)=0) or RowNo()=1,1,0),AnzTAge,Datum)