topic Re: Add adjusted testnumber column. in Discussions

Add adjusted testnumber column.

ConfidenceOwl94 — Sun, 09 Feb 2025 20:16:30 GMT

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.

Re: Add adjusted testnumber column.

jthi — Sun, 09 Feb 2025 20:35:04 GMT

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)

Re: Add adjusted testnumber column.

ConfidenceOwl94 — Mon, 10 Feb 2025 01:15:12 GMT

Thanks Jarmo,

How did you added Testnr column? manually?

Re: Add adjusted testnumber column.

txnelson — Mon, 10 Feb 2025 02:37:06 GMT

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
		)
	)
);

Re: Add adjusted testnumber column.

ConfidenceOwl94 — Mon, 10 Feb 2025 14:03:08 GMT

Thanks Jim,

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

Re: Add adjusted testnumber column.

jthi — Mon, 10 Feb 2025 14:06:47 GMT

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