HeatMap in Graph builder is a great way to visualize data: https://community.jmp.com/t5/Learning-Center/Creating-Heat-Maps/ta-p/271828 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: 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 ) ) )
);
... View more