nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

735211_en-US

liliconcom

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

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.

Automation and Scripting

Basic Data Analysis and Modeling

Data Exploration and Visualization

Mass Customization

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

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