BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
mhalwi

Community Trekker

Joined:

Dec 12, 2017

Need help to populate the correct column value in the distribution graph

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

2 REPLIES 2
uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

Re: Need help to populate the correct column value in the distribution graph

@mhalwi
     Maybe this discussion could be helpful to you . 

 

https://community.jmp.com/t5/Discussions/How-to-insert-data-labels-in-graph-builder/td-p/28747 

 

 

Best
Uday
mhalwi

Community Trekker

Joined:

Dec 12, 2017

Re: Need help to populate the correct column value in the distribution graph

Hi @uday_guntupalli
i have read the suggestion post that u mentioned above but i can really relate it on how to use it for my script. ill look more in the suggestion for the same issue as this.

thanks