New Column to show repeated values in for each run/ID across two data types

[#1]

I tried using lag function to indicate when the first test for a sample ID based on time column. Need to the column, Order Tested, to represent first test conducted for a sample ID and second test based on time. Each test will have a real and maybe a code value. See attached file for JMP file. At the end of the day Order Tested column needs to look like image below. This is just a sample, real one has 10,000+ data points.

[#2 · Accepted solution]

You can use Col Cumulative Sum with if statement

Col Cumulative Sum(If(Row() == Col Min(Row(), :Sample ID, :Time, :DataType), 1, .), :Sample ID, :DataType)

KudosAdd dense ranking to Ranking Tie and Col Rank functions to make this much much easier

[#3]

Thanks for the solution!