topic Re: how to number rows based on column values in Discussions

how to number rows based on column values

ExcitedOwl — Sun, 24 Sep 2023 10:13:18 GMT

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

txnelson — Sun, 24 Sep 2023 11:25:34 GMT

Here is the formula that I normally use

Col Cumulative Sum( 1, :SN );

Craige_Hales — Sun, 24 Sep 2023 11:45:16 GMT

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

hogi — Mon, 25 Sep 2023 18:49:12 GMT

If you cannot guarantee that the entries are sorted, use

Col Rank(:START_TIME_UTC,:SN)