nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

269522_en-US

liliconcom

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

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

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?

Comments

There are no comments yet