Hi All,
I am new to the JMP scripting. I need help to populate the data that i calculate to the distribution graphs plotted. For example, i have 3 distribution graph plotted and there are 3 value was calculated out from the graph plotted.
So, i want to use each respective value from each graph and plotted it again on each respective graph it was calculated. There are few problems i am facing right now as below.
1. How to insert the value calculated from each graph to its respective graph. i try to wildcard (*) but seems not working. The graph has its own name so im thinking wildcard can help me here but it is not working.
2. The value calculated from each graph is in the summary table, so if i try to put the value manually to the graph by using the reference name in the summary table, it will always take the last value in the table and didnt not refer to its respective value it was calculated.
sample code and example for summary table are as below:
you can see in the second distribution graph in the code i try to called the value calculated using formula 'LSL' and 'USL' which is 'LSL_Calc=0.047' and 'USL_Calc=0.0869' for Speed_Test, but it will always take the last value from Stress_Test value to draw on the disctribution graph . How to make it know that it need to the value from its respective TEST_NAME which is Speed_Test. Is there any array or somekind command that i need to use?
| TEST_NAME |
N Rows |
Mean(NUMERIC_RESULT) |
Std Dev(NUMERIC_RESULT) |
LSL_Calc |
USL_Calc |
| Drop_Test |
5 |
0.2942 |
0.031518 |
0.105092 |
0.483308 |
| Speed_Test |
5 |
0.06705 |
0.003314 |
0.047167 |
0.086933 |
| Hot_Test |
5 |
0.52175 |
0.009736 |
0.463337 |
0.580163 |
| Stress_Test |
5 |
0.39655 |
0.044266 |
0.130956 |
0.662144 |
dt = Open ("C:\Users\malwi\Desktop\MyAutomation\Newtable\table1.csv");
Distribution(
SendToByGroup( Bygroup Default ),
Stack( 1 ),
Continuous Distribution(
Column( :NUMERIC_RESULT ),
Horizontal Layout( 1 ),
Vertical( 0 ),
Count Axis( 1 ),
Normal Quantile Plot( 1 )
),
By( :TEST_NAME );
);
Summary(
Group(:TEST_NAME ),
Mean( :NUMERIC_RESULT ),
Std Dev( :NUMERIC_RESULT )
);
New Column( "LSL_Calc",
Numeric,
Continuous,
Format( "Best", 8 ),
Formula(
LSL = :Name( "Mean(NUMERIC_RESULT)" ) - 6 *:Name( "Std Dev(NUMERIC_RESULT)" )
),
);
New Column( "USL_Calc",
Numeric,
Continuous,
Format( "Best", 8 ),
Formula(
USL = :Name( "Mean(NUMERIC_RESULT)" ) + 6 *:Name( "Std Dev(NUMERIC_RESULT)" )
),
);
wait(1);
dr = Fit Group (
Distribution(
SendToByGroup( Bygroup Default ),
Stack( 1 ),
Continuous Distribution(
Column( :NUMERIC_RESULT ),
Horizontal Layout( 1 ),
Vertical( 0 ),
Count Axis( 1 ),
Normal Quantile Plot( 1 )
),
By( :TEST_NAME ),
SendToByGroup(
{:TEST_NAME ==
"Drop_Test"},
SendToReport(
Dispatch(
{
"Distributions TEST_NAME=Drop_Test",
"NUMERIC_RESULT"},
"1",
ScaleBox,
{Min( 0.1 ), Max( 0.49 ), Inc( 0.02 ), Minor Ticks( 1 ),
Add Ref Line( 0.11, Solid, "Red", "LSL", 2 ),
Add Ref Line( 0.48, Solid, "Red", "USL", 2 )}
)
)
),
SendToByGroup(
{:TEST_NAME ==
"Speed_Test"
},
SendToReport(
Dispatch(
{
"Distributions TEST_NAME=Speed_Test",
"NUMERIC_RESULT"},
"1",
ScaleBox,
{Min( LSL + 0.04 ), Max( USL + 0.1 ), Inc( 0.002 ), Minor Ticks( 1 ),
Add Ref Line( LSL , Solid, "Red", "LSL", 2 ),
Add Ref Line( USL , Solid, "Red", "USL", 2 )}
)
)
)
)
)<<report;
Please help me on this. Your help is really appreciated!!
