Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
marktaylor
Level II

Heat Map / Aggregate Function

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 REPLIES 2
Highlighted

Re: Heat Map / Aggregate Function

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?

Learn it once, use it forever!
Highlighted
marktaylor
Level II

Re: Heat Map / Aggregate Function

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
Article Labels

    There are no labels assigned to this post.