cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
View Original Published Thread

Add adjusted testnumber column.

ConfidenceOwl94
Level III

ConfidenceOwl94_0-1739131842217.png

I am not sure this is even possible. I do have test time stamp but they are not accurate.

 

I like to add a test number column, but for the retested parts i want test number 2 not 1.

5 REPLIES 5
jthi
Super User


Re: Add adjusted testnumber column.

One option is to add testnumber to your data table, sort your data and utilize that

Col Cumulative Sum(If(Row() == Col Min(Row(), :testnr, :Serial Number), 1, 0), :Serial Number)

jthi_0-1739133273054.png

 

-Jarmo
ConfidenceOwl94
Level III


Re: Add adjusted testnumber column.

Thanks Jarmo,

How did you added Testnr column? manually?

txnelson
Super User


Re: Add adjusted testnumber column.

I am sure that Jarmo added it manually.

 

JSL to create the new column would be:

 

Names Default To Here( 1 );

Current Data Table() << New Column( "Column 6",
	formula(
		Col Cumulative Sum(
			If( Row() == Col Min( Row(), :testnr, :Serial Number ),
				1,
				0
			),
			:Serial Number
		)
	)
);
Jim
ConfidenceOwl94
Level III


Re: Add adjusted testnumber column.

Thanks Jim,

I am talking about 'Testnr' Column. He used that in Column 6 formula. 

ConfidenceOwl94_0-1739196180226.png

 

jthi
Super User


Re: Add adjusted testnumber column.

I added it manually. We don't know what data you have available, so I assumed you would be able to access that as it was visible in your sheet which seems to be base for the JMP table.

 

Edit: It might be possible to add it as a formula but more information of the data might be required for that

-Jarmo