topic How to count Flag changes? in App Development

How to count Flag changes?

chr_pro — Tue, 28 Feb 2023 14:34:33 GMT

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 — Tue, 28 Feb 2023 20:43:18 GMT

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

chr_pro — Wed, 01 Mar 2023 07:41:54 GMT

Hi Marco,

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

sergio0592 — Wed, 01 Mar 2023 10:45:37 GMT

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)