Subscribe Bookmark RSS Feed

JSL - Choosing the maximum value in a column

abdulj

Community Trekker

Joined:

Jul 12, 2011

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
Solution

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

3 REPLIES
Solution

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

abdulj

Community Trekker

Joined:

Jul 12, 2011

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

Joined:

Jul 13, 2011

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