How to directly calculate the number of consecutive conditions?
This widget could not be displayed.
Created:
Nov 18, 2019 07:30 AM
| Last Modified: Nov 18, 2019 4:30 AM(3662 views)
For example, take "height" as an example and count the consecutive number of "height"s in the row greater than the "height" in the previous row.
I added an auxiliary column h to determine whether the "height" of the row is greater than the "height" of the previous row, and then counted the consecutive "height" of the row greater than the "height" of the previous row in the other column.If the "height" is less than the "height" of the previous row have to recalculate.