cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
ExcitedOwl
Level I

how to number rows based on column values

Hi All,

 

I have a table with SN and timestamp for each. I need to number the lines per each SN based on timestamp.

the table is sorted by time and I wanted to use ROW() with grouping by SN, but i don't know how to do it.

appreciate your help,

Thanks

ExcitedOwl_1-1695550260374.png

 

3 REPLIES 3
txnelson
Super User

Re: how to number rows based on column values

Here is the formula that I normally use

Col Cumulative Sum( 1, :SN );
Jim
Craige_Hales
Super User

Re: how to number rows based on column values

@jthi  did something similar with ColSum(); here's an explanation of how it works:

https://community.jmp.com/t5/Discussions/Countif-equivalent/m-p/664313/highlight/true#M85267

Craige
hogi
Level XIII

Re: how to number rows based on column values

If you cannot guarantee that the entries are sorted, use

Col Rank(:START_TIME_UTC,:SN)

Recommended Articles