"On the fly" distribution-report and using variables

Question

Two issues: 1. How do I get the sigma value from the histogram I just ploted to re-scale the bin of the plot? 2. How do I add ref lines (from different table) to each test name plot? Thank you very much in advance! "STD"- is the std value from the statistics table "???"- is a value from "limits" table. dt1 = Open(); :result << Set Data Type( Numeric, "Continuous" ); limits = dt1 << Summary( Group( :test_name ), Mean( Eval( "range_min" ) ), Mean( Eval( "range_max" ) ), ); Ntests = N Rows( limits ); vl = V List Box( Text Box( "Spec Limits Script" ) ); dt1 << Distribution( Continuous Distribution( Column( :result ), Horizontal Layout( 1 ), Vertical( 0 ) ), By( :test_name ), SendToReport( Dispatch( {"result"}, "1", ScaleBox, {Min( 97.5173285198556 ), Max( 97.9576714801444 ), Inc(?STD?), Minor Ticks( 0 ), Add Ref Line( limits[???,3], "Solid", "Black", "", 1 ), Add Ref Line( limits[???,4], "Solid", "Black", "", 1 )} ) ) );

ian_jmp · Answer

This seems to be the same question as that which is now addressed in a parallel thread.

Idokol · Answer

Please see attached file.

Distribution by "test_name"

add line by range_max & range_min

bin size by std.

Thanks!

SampleSet.jmp

ian_jmp · Answer

OK. It seems like you then have two 'issues'; one is that the variables 'ref1Val', 'ref2Val' and 'IncVal' are assigned a priori, and the other is that you need to use a 'By' variable. But both are easily overcome.

The values mentioned could have been computed or looked up by other JSL (rather than given values through assignments, as above).

And when using a 'By' variable, the details may depend a little on whether or not you know the number of groups in advance. But the use of 'SubstituteInto()' will probably be the same. Some sample data and values would assist greatly if you need or want more help.