topic Re: Increasing trend using Jmp Code in Discussions

Increasing trend using Jmp Code

AlphaPanda86751 — Sun, 11 Jun 2023 11:49:33 GMT

Hi,

I have a cycle (Cycle 2) that last for certain rows and then increases its step. For each cycle, I would like to make another column(Column 7) and assign an increasing trend of same numbers but I could not figure out the code for this.

Re: Increasing trend using Jmp Code

Georg — Tue, 23 Aug 2022 10:27:58 GMT

Perhaps it is ->> Tables --> Split that can help you?

Re: Increasing trend using Jmp Code

AlphaPanda86751 — Tue, 23 Aug 2022 10:49:35 GMT

@George

Thanks

I don't have the trend column as you show. I want to create "trend" and assign an increasing order of numbers to it

I only have this

Re: Increasing trend using Jmp Code

jthi — Tue, 23 Aug 2022 11:08:18 GMT

Try Col Rank formula

Col Rank(:"Cycle 2"n, :"Cycle 2"n)