topic Finding value of column y at max value of column X in Discussions

Finding value of column y at max value of column X

sipho-ss — Sat, 10 Jun 2023 23:52:17 GMT

I want to find the maxium value in column "Power (dBm)" grouped by BarID, ChipID.

And use that to find the corresponding value in column "Wavelength (nm)" to give me a summary table showing the value of maxium power and what value of wavelngth it occurs at grouped by BarID, ChipID etc.

Re: Finding value of column y at max value of column X

txnelson — Tue, 02 Aug 2022 00:41:48 GMT

Here is an example of doing a similar thing using the Big Class data table

Names Default To Here( 1 );
dt = 
// Open Data Table: big class.jmp
// → Data Table( "big class" )
Open( "$SAMPLE_DATA/big class.jmp" );

dt << select where(col max(:height,:sex) == :height );

dt << subset(selected rows(1), columns({"Sex","Height","Weight"}));