cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-416721%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EVisualizaci%C3%B3n%20directa%20de%20los%20resultados%20de%20la%20tabla%20de%20resumen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-416721%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EMe%20gustar%C3%ADa%20saber%20c%C3%B3mo%20visualizar%20los%20resultados%20agregados%20directamente.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPor%20ejemplo%2C%20digamos%20que%20quiero%20obtener%20el%20valor%20m%C3%A1ximo%20de%20etanol%20por%20lote%20(conjunto%20de%20datos%20de%20muestra%20de%20fermentaci%C3%B3n).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FN_0-1631172840033.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22FN_0-1631172840033.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35646iDE3252BBF764864F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FN_0-1631172840033.png%22%20alt%3D%22FN_0-1631172840033.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20partir%20de%20hoy%2C%20creo%20una%20tabla%20de%20resumen%20o%20realizo%20un%20an%C3%A1lisis%20tabulado%20antes%20de%20hacer%20el%20gr%C3%A1fico.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EData%20Table(%20%22Fermentation%20Process%22%20)%20%26lt%3B%26lt%3B%20Summary(%0A%20Group(%20%3ABatchID%20)%2C%0A%20Max(%20%3AEthanol%20)%2C%0A%20Freq(%20%22None%22%20)%2C%0A%20Weight(%20%22None%22%20)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EUn%20punto%20por%20lote.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FN_3-1631173109519.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22FN_3-1631173109519.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35649i4DAD395EA807DAE5%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FN_3-1631173109519.png%22%20alt%3D%22FN_3-1631173109519.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESin%20embargo%2C%20puedo%20usar%20una%20f%C3%B3rmula%20JMP%20con%20funciones%20de%20columna%20agrupadas%20por%20variables.%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ECol%20Maximum(%20%3AEthanol%2C%20%3ABatchID%20)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3ESi%20los%20trazo%2C%20se%20repetir%C3%A1%20el%20resultado%20agregado%20(puntos%20de%20muestra%20por%20lote).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FN_2-1631173080268.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22FN_2-1631173080268.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F35648i550AD48093B24E79%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FN_2-1631173080268.png%22%20alt%3D%22FN_2-1631173080268.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%C2%BFAlguna%20idea%20sobre%20c%C3%B3mo%20trazar%20los%20resultados%20agregados%20directamente%20para%20tener%20un%20punto%20por%20lote%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPrefiero%20evitar%20tener%20que%20manejar%20varias%20tablas%20de%20datos.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-416721%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3ETabla%20de%20datos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGr%C3%A1ficos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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

 

Recommended Articles