cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
abdulj
Level IV

JSL - Choosing the maximum value in a column

Hello

I am trying to produce pareto plot using the 3 most recent data set. How can I choose the maximum value of a given column?? I tried max() but that doesn't seem to work.

Here's what I have for this part of my script:

Pareto Plot( Cause( :Defect Desc ), Freq( :Defect Ct ), Where( :Date == Max(:Date) ) );

Pareto Plot( Cause( :Defect Desc ), Freq( :Defect Ct ), Where( :Date == Max(:Date) -1 ) );

Pareto Plot( Cause( :Defect Desc ), Freq( :Defect Ct ), Where( :Date == Max(:Date) -2 ) );


Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

JSL - Choosing the maximum value in a column

Try using Col Max() instead of Max().

View solution in original post

3 REPLIES 3
ms
Super User (Alumni) ms
Super User (Alumni)

JSL - Choosing the maximum value in a column

Try using Col Max() instead of Max().

abdulj
Level IV

JSL - Choosing the maximum value in a column

Great, thanks.

One last thing, any ideas on how I can get rid of the text at the top of the attached screenshot (Where( Col Max( :Date ) - 3 <= :Date <= Col Max( :Date ) ))??

1244_Screen Shot 2011-10-21 at 10.19.00 AM.jpg

Here's the code snippet:

H List Box(

  V List Box(

  Data Table( "XXX" ) << Pareto Plot(

                                                  Cause( :Defect Desc ),

                                                  Freq( :Defect Ct ),

                                                  X( :Date ),

                                                  Where( Col Max( :Date ) - 3 <= :Date <= Col Max( :Date ) )

                                        ),

David_Burnham
Super User (Alumni)

JSL - Choosing the maximum value in a column

Try this:

H List Box(

  V List Box(

  pp = Data Table( "XXX" ) << Pareto Plot(

                                                  Cause( :Defect Desc ),

                                                  Freq( :Defect Ct ),

                                                  X( :Date ),

                                                  Where( Col Max( :Date ) - 3 <= :Date <= Col Max( :Date ) )

                                        ),

....

ppr = pp << Top Report;

tb = ppr[ Text Box(1) ];

tb << Delete;


-Dave