Choose Language Hide Translation Bar

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

1 ACCEPTED SOLUTION

Accepted Solutions

## JSL - Choosing the maximum value in a column

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

3 REPLIES 3

## JSL - Choosing the maximum value in a column

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

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

),

Highlighted  David_Burnham
Super User

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