I would like to know how to visualize aggregated results directly.
For example, let's say I want to obtain the maximum value of the ethanol per batch (fermentation sample data set).
![FN_0-1631172840033.png FN_0-1631172840033.png](https://community.jmp.com/t5/image/serverpage/image-id/35646iDE3252BBF764864F/image-size/medium?v=v2&px=400)
As of today, I create a summary table or perform a tabulate analysis before doing the graph.
Data Table( "Fermentation Process" ) << Summary(
Group( :BatchID ),
Max( :Ethanol ),
Freq( "None" ),
Weight( "None" )
)
One point per batch.
![FN_3-1631173109519.png FN_3-1631173109519.png](https://community.jmp.com/t5/image/serverpage/image-id/35649i4DAD395EA807DAE5/image-size/medium?v=v2&px=400)
However, I can use a JMP formula with column functions grouped by variables.
Col Maximum( :Ethanol, :BatchID )
If I plot these, I will have the aggregated result repeated (sample points per batch).
![FN_2-1631173080268.png FN_2-1631173080268.png](https://community.jmp.com/t5/image/serverpage/image-id/35648i550AD48093B24E79/image-size/medium?v=v2&px=400)
Any ideas on how to plot the aggregated results directly so I have one point per batch?
I prefer to avoid having to handle several data tables.