...
6.13 Find out interval in which a certain condition occurs continuously
We have a statistical table for daily sales:
Find out the date when the sales rises for three consecutive days or more:
| A | |
|---|---|
| 1 | =0 |
| 2 | =E(‘A1:B32’).group@o(if(Sales>Sales[-1], A1,A1=A1+1)).select(~.len()>=3).conj() |
A2: Take A1 as a temporary value. A1 remains unchanged when the sales rises, and plus 1 when the sales falls, and then group according to this temporary value. In this way, the rows of consecutive rise are put into the same group.
