topic Add test number column based on different column value changes in Discussions

Add test number column based on different column value changes

ConfidenceOwl94 — Fri, 07 Feb 2025 22:58:33 GMT

I have a data of a parts that are being tested on different test tester. If part fail on it won't be tested on next stations. I like to add a column to track the test number.

Re: Add test number column based on different column value changes

txnelson — Sat, 08 Feb 2025 04:57:49 GMT

Here is how I would approach the problem with this formula for the column

As Constant( val = 0 );
If( Lag( :Serial Number ) != :Serial Number,
	val = 0
);
If( :Tester == "Tester 1",
	val
	++);
val;

Re: Add test number column based on different column value changes

ConfidenceOwl94 — Sun, 09 Feb 2025 19:09:59 GMT

Thanks Jim