topic JSL - Choosing the maximum value in a column in Discussions

JSL - Choosing the maximum value in a column

abdulj — Thu, 20 Oct 2011 22:13:41 GMT

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

JSL - Choosing the maximum value in a column

ms — Fri, 21 Oct 2011 00:10:01 GMT

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

JSL - Choosing the maximum value in a column

abdulj — Tue, 18 Oct 2016 19:51:30 GMT

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

JSL - Choosing the maximum value in a column

David_Burnham — Sun, 23 Oct 2011 00:35:32 GMT

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;