cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
aallman
Level III

Heatmap Using Maximum instead of Mean

Hello

 

Is it possible to create a heatmap using the maximum value at each (x, y) rather than the average?

 

Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Heatmap Using Maximum instead of Mean

You can do this, but you have to preprocess the statistics.  See the simple script below for an example

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
dtmax = dt << Summary( Group( :sex, :age ), Max( :height ), Freq( "None" ), Weight( "None" ) );
New Window( "graphs",
	H List Box(
		dt << Graph Builder(
			Size( 570, 520 ),
			Variables( X( :SEX ), Y( :Age ), Color( :height ) ),
			Elements( Heatmap( X, Y, Legend( 4 ) ) )
		),
		dtmax << Graph Builder(
			Size( 570, 520 ),
			Variables( X( :SEX ), Y( :Age ), Color( :name( "max(height)" ) ) ),
			Elements( Heatmap( X, Y, Legend( 4 ) ) )
		)
	)
);

Heat Map.PNG

Jim

View solution in original post

1 REPLY 1
txnelson
Super User

Re: Heatmap Using Maximum instead of Mean

You can do this, but you have to preprocess the statistics.  See the simple script below for an example

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
dtmax = dt << Summary( Group( :sex, :age ), Max( :height ), Freq( "None" ), Weight( "None" ) );
New Window( "graphs",
	H List Box(
		dt << Graph Builder(
			Size( 570, 520 ),
			Variables( X( :SEX ), Y( :Age ), Color( :height ) ),
			Elements( Heatmap( X, Y, Legend( 4 ) ) )
		),
		dtmax << Graph Builder(
			Size( 570, 520 ),
			Variables( X( :SEX ), Y( :Age ), Color( :name( "max(height)" ) ) ),
			Elements( Heatmap( X, Y, Legend( 4 ) ) )
		)
	)
);

Heat Map.PNG

Jim