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:

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.