May I ask whether these two steps can be completed by a formula?

Question

1. In the original ranking situation, we first found out that the weight was the largest position among the three people before and after the belief (7 people were compared each time).
2. Then find the number of lines between the equals sign of each line and the maximum weight.
(when he has a maximum weight, his subsequent lines are compared with the new maximum weight.)
This table data in dt = Open("$SAMPLE_DATA/Big class.jmp ");I can only add 2 columns to the file to complete it.

ih · Answer

Here is an option to do this in one column, note the new column name is 'IntervalNew':

Script to create the column for you using the big class data table:

View more... (Highlight to read)names default to here(1);
dt = open("$SAMPLE_DATA/big class.jmp");
dt << New Column( "IntervalNew",
	Numeric,
	"Continuous",
	Format( "Best", 12 ),
	Formula(
		If(
			Row() == 1, 1,
			:weight == Max( :weight[Index( Row() - 3, Row() + 3 )] ), 0,
			Lag( :IntervalNew ) + 1
		)
	)
);

names default to here(1);
dt = open("$SAMPLE_DATA/big class.jmp");
dt << New Column( "IntervalNew",
	Numeric,
	"Continuous",
	Format( "Best", 12 ),
	Formula(
		If(
			Row() == 1, 1,
			:weight == Max( :weight[Index( Row() - 3, Row() + 3 )] ), 0,
			Lag( :IntervalNew ) + 1
		)
	)
);

lwx228 · Answer

It seems to work.I want a better way,Thanks!

Quick Links