Heat maps -> median aggregation [and more]

[hogi]

HeatMap in Graph builder is a great way to visualize data:

https://community.jmp.com/t5/Learning-Center/Creating-Heat-Maps/ta-p/271828

hogi_2-1667399031694.png

Individual "tiles" can represent several rows of the data table (geographic region: data of many countries).
Then the values of the rows are averaged automatically. This is very convenient

- but "averaging" (mean) is just one option ...

If the user wants to do different aggregations, he has to generate a summary table or use a formula column with exactly the same grouping settings as the desired heat map:

https://community.jmp.com/t5/Discussions/Heat-Map-Aggregate-Function/td-p/269522

A more straight-forward and flexible approach:

In GraphBuilder/Heat Map, please provide a menu to select the aggregation method:

- median

- any item from the summary table menu:

hogi_1-1667397910692.png

View more...

dt =Open( "$SAMPLE_DATA/Big Class.jmp" );
dt:height[32]=500;


Data Table( "Big Class" ) << Graph Builder(
	Size( 336, 478 ),
	Graph Spacing( 4 ),
	Variables( X( :sex ), Y( :age ), Color( :height ) ),
	Elements( Heatmap( X, Y, Legend( 4 ) ) )
);

[jthi]

Can't user already do this by using Color property and by changing summary statistic in that? If no color column is defined heatmap will use Count (that is really only thing it can use without "third axis"?).

jthi_0-1667400461515.png

[hogi]

you are right, wonderful!

[hogi]

btw.
the summary statistic menu is always available, not just for heatmap plots.

But it seems to have just an effect for heatmaps, right?

hogi_0-1667408175301.png

[Sarah-Sylvestre]

Marking as delivered since a solution is provided in the comments. Thanks all!