Heat maps -> median aggregation [and more]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:
View more... Automation and ScriptingData Blending and CleanupData Exploration and VisualizationRe: Heat maps -> median aggregation [and more] - Status changed to: DeliveredMarking as delivered since a solution is provided in the comments. Thanks all!
Re: Heat maps -> median aggregation [and more]btw.
the summary statistic menu is always available, not just for heatmap plots.
But it seems to have just an effect for heatmaps, right?
Re: Heat maps -> median aggregation [and more]you are right, wonderful!
Re: Heat maps -> median aggregation [and more]Can't user already do this by using Color property and by changing summary statistic in that? If no color column is defined heatmap will use Count (that is really only thing it can use without "third axis"?).
