This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
How to directly calculate the number of consecutive conditions?
Nov 18, 2019 07:30 AM(2560 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.