How can I find the result without looping?

[#1]

For example, the number of piles according to the height value greater than 63:

This heap number refers to: when the number of adjacent rows is more than 63 consecutively, the count is 1, so the count should be 8.

The result can be obtained in a circular way, please ask if there are other ways to get the result. Thanks!

[#2]

Maybe something like this:

If(Row() == 1, cur_val = 1);
If(:height > 63 & Lag(:height) <= 63,
	cur_val
	++);

[#3]

Sum(:height[Index(1,Row()-1)]<=63&:height[Index(2,Row())]>63)

[#4]

When the amount of data is large, the time-consuming methods of the two experts are quite different. Thanks again!