Variable incrementation

[Pouchy]

Hi everyone,

This might be a stupid question, but I have this :

I just want a new column, starting from 0, and each time there is a 1 in "New Field", I want to increment my variable (+1).

So for the picture above, I want 1 from 01/01 to 07/01, then 2 from 08/01 to ...

I try "Generate rows" but it doesn't seems to work.

Any ideas?

[Thableaus · Accepted solution]

Hi @Pouchy 

Use Multi-Row Formula Tool - (no group by checked)

IF [New Field] = 1 THEN [Row-1:Variable] + 1

ELSE [Row-1:Variable]  ENDIF

[Pouchy]

Thank you very much !