https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441555#M68978 <P>例如按身高的数值大于63的堆数:</P> <P>&nbsp;</P> <P>这个堆数是指:当相邻行数连续大于63时计数为1、这样计数应该是有 8&nbsp;</P> <P>这个用循环的方式能得到结果、请教是否还有其它方式可以得到结果。谢谢！</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-12-02_154024.png" style="width: 332px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/38090iC85DFD726CC857F2/image-size/large?v=v2&amp;px=999" role="button" title="2021-12-02_154024.png" alt="2021-12-02_154024.png" /></span></P> Fri, 09 Jun 2023 18:06:31 GMT lala 2023-06-09T18:06:31Z https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441555#M68978 <P>例如按身高的数值大于63的堆数:</P> <P>&nbsp;</P> <P>这个堆数是指:当相邻行数连续大于63时计数为1、这样计数应该是有 8&nbsp;</P> <P>这个用循环的方式能得到结果、请教是否还有其它方式可以得到结果。谢谢！</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-12-02_154024.png" style="width: 332px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/38090iC85DFD726CC857F2/image-size/large?v=v2&amp;px=999" role="button" title="2021-12-02_154024.png" alt="2021-12-02_154024.png" /></span></P> Fri, 09 Jun 2023 18:06:31 GMT https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441555#M68978 lala 2023-06-09T18:06:31Z https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441564#M68979 <P>Maybe something like this:</P> <PRE><CODE class=" language-jsl">If(Row() == 1, cur_val = 1); If(:height &gt; 63 &amp; Lag(:height) &lt;= 63, cur_val ++);</CODE></PRE> Thu, 02 Dec 2021 08:03:48 GMT https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441564#M68979 jthi 2021-12-02T08:03:48Z https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441565#M68980 <PRE><CODE class=" language-jsl">Sum(:height[Index(1,Row()-1)]&lt;=63&amp;:height[Index(2,Row())]&gt;63)</CODE></PRE> Thu, 02 Dec 2021 08:08:36 GMT https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441565#M68980 lwx228 2021-12-02T08:08:36Z https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441907#M69014 <P>当数据量很大时、两个专家的方法耗时方面是有较大差异的。再次感谢!</P> Fri, 03 Dec 2021 03:14:48 GMT https://community.jmp.com/t5/Discussions/%E5%A6%82%E4%BD%95%E8%83%BD%E4%B8%8D%E7%94%A8%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E6%B1%82%E5%87%BA%E7%BB%93%E6%9E%9C/m-p/441907#M69014 lala 2021-12-03T03:14:48Z