- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Add adjusted testnumber column.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Add adjusted testnumber column.
Thanks Jarmo,
How did you added Testnr column? manually?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
)
)
);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Add adjusted testnumber column.
Thanks Jim,
I am talking about 'Testnr' Column. He used that in Column 6 formula.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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