reading data from peak - y and x data

[#1]

Hi,

I am having JMP 18 and I am looking for a way to read the max peak - I´d like to have the max y and equivalent x value. 

[#2]

Here is a simple script that will write the values to the log

names default to here(1);
dt = current data table();

theRow = (dt << get rows where(col max(:signal)==:signal))[1];
show(:"time, min"n[theRow],:signal[theRow]);

[#3]

hi, thanks for the great input.

Is there away that it does the data picking for all IDs?

[#4 · Accepted solution]

It requires just a simple modification to the JSL I originally provided.

names default to here(1);
dt = current data table();

// Find all of the peaks
theRows = (dt << get rows where(col max(:signal, :ID)==:signal));

// Display results
New window("Peak Maximums",
	table box(
		string col box("ID", :ID[theRows]),
		number col box("time, min",:"time, min"n[theRows]),
		number col box("signal", :signal[theRows])
	)
);

// Select the rows in the data table
dt << clear select;
dt << select rows(theRows);