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 ) ) )
);