topic Grouping Data in Discussions

Grouping Data

eldad_galili — Sat, 10 Jun 2023 23:14:41 GMT

Hi,

I would like to group data as the attached image.

whenever there is a "No" the result will be a 0.

When ever there is a "Yes" the result will be a running number (1,2,3...) for each group.

How do I implement this in a formula (or script?).

Thank you very much.

Mark_Bailey — Tue, 16 Jun 2020 16:42:01 GMT

Copy this expression and paste it into the Formula Editor for the Grouping column:

If(
	Row() == 1,
		temp = :Y == "Yes";
		temp;,
	:Y == "Yes" & Lag( :Y ) == "No",
		temp++;
		temp;,
	:Y == "Yes", temp,
	0
)

Change the name of Y to the original data column.

eldad_galili — Tue, 16 Jun 2020 17:00:01 GMT

Thank you very much :)