Heat Map / Aggregate Function

[#1]

I wondered if anyone can point me in the right direction. I have a script that creates a table with Row, Column and Data fields (multiple Data field values for each (Row,Column) pair). I'd like to be able to create a Heat Map showing the Range for each Row and Column pair. By default the Mean is plotted. I can create an aggregated field (sum, median, std deviation and some others are included but not Range). Does anyone have any tips for how I might do this. Thanks, Mark

[#2]

Please show us an example of the data table on which you are working. Do the data values go across a row or down a column?

[#3]

Thanks Mark. I managed to do what I want by selecting Tables > Summary then selecting Range from the Statistics dropdown for the data field and selecting Row and Col in the Group By part. The data goes down the column

[#4]

easiest way is via Color/SummaryStatistic
https://community.jmp.com/t5/JMP-Wish-List/Add-option-to-color-heatmap-in-Graph-Builder-by-statistic... 

@jthi : many thanks for this info ...