JSL - Choosing the maximum value in a column

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

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

                                        ),

[#4]

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;