topic Heat Map / Aggregate Function in Discussions

Heat Map / Aggregate Function

marktaylor — Fri, 29 May 2020 09:55:48 GMT

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

Re: Heat Map / Aggregate Function

Mark_Bailey — Fri, 29 May 2020 11:36:16 GMT

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?

Re: Heat Map / Aggregate Function

marktaylor — Fri, 29 May 2020 12:17:43 GMT

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

Re: Heat Map / Aggregate Function

hogi — Wed, 02 Nov 2022 15:54:17 GMT

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

@jthi : many thanks for this info ...