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.
esProc Desktop and Excel Processing
6.12 Filter by maximum or minimum value within a group (find out one for each group)
7.1 Simple column-wise aggregation
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL
