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).
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.
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).
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.