Removing Rows with insufficient data

[#1]

I am running electrical characterization on a bunch of devices. Some of those devices are failing immediately and when I run the JMP app I made they show up as blank or single point plots that take up a large portion of the my screen.

I would like to delete all of the data with only a few points. I have indexed the number of I have tried to get a maximum index and then delete where that number is below 1000..

// Make a new table to find maximum Tag
dt << New Column( "Maximum[Tag]",
	Numeric,
	"Continuous",
	Format( "Best", 12 ),
	Formula( Col Maximum( :Tag ) )
) << Move Selected Columns( {:"Maximum[Tag]"n}, after( :Tag ) );

// Find where Maximum[Tag] < 1000 and delete those rows
dt << Select where( :"Maximum[Tag]"n < 1000 );
dt << delete rows;

I'm running into the problem where it's not finding the maximum for each File Name (String in column :File Name) and is just coming back with the maximum in the entire column.

Is it possible to iterate this for each item in my File Name column? Or is there a better way of clearing out this data?

Thanks in advance for your help!

[#2 · Accepted solution]

Use :"File Name"n as byVar in Col Maximum

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Column("Maximum Value for Each Age and Sex Group",
	Formula(Col Maximum(:height, :age, :sex))
);

[#3]

Thank you! I was definitely over complicating this!