Subscribe Bookmark RSS Feed

Heatmap Using Maximum instead of Mean

aallman

Contributor

Joined:

Feb 28, 2017

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

Joined:

Jun 22, 2012

Solution

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
1 REPLY
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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