cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
FN
FN
Level VI

Direct visualization of summary table results

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

 

 

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

 

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

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
FN
FN
Level VI

Re: Direct visualization of summary table results

It was really simple.

 

FN_0-1631174299074.png

 

View solution in original post

1 REPLY 1
FN
FN
Level VI

Re: Direct visualization of summary table results

It was really simple.

 

FN_0-1631174299074.png