News
We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
Mark_ON
Level II

Extracting values from a Gauge RR report

I'm wondering if there is a straightforward way to extract the "Gauge R&R % of tolerance" value from a Gauge RR report in jmp, or if I'll have to figure something out using xpath. I want this value for use in a high level summary report. Script is probably not that important for this question but this is what I have so far:

 

For( k = 1, k <= (N Cols(GAGEdT) - 4), k++,

	s = column(GAGEdT, k) << Get Property( "Spec Limits" ); 
	usl = s["USL"];
	lsl = s["LSL"];

	rw << Append(ob = Outline Box (Eval(Char(Column Name(k))),
		
		vc = Variability Chart(
			Y( Column(Eval(k))),
			X( :tester, :test site, :Hardware SN ),
			Model( "Crossed" ),
			Max Iter( 100 ),
			Conv Limit( 0.00000001 ),
			Number Integration Abscissas( 128 ),
			Number Function Evals( 65536 ),
			Analysis Type( Name( "Choose best analysis (EMS REML Bayesian)" ) ),
			Historical Sigma( 0 ),
			Std Dev Chart( 0 ),
			Gauge RR( 6, usl-lsl, lsl, usl ),
			Name( "Reduced Gauge R&R Report" )(1),

			Show Box Plots (1),
			Show Points(0),
			
			SendToReport(
				Dispatch(
				{},
				"Variability Chart",
				FrameBox,
				{Frame Size( eval(window_width), 400 )}))

		);		
	));
);

 

0 Kudos
2 REPLIES 2
Highlighted
Mark_ON
Level II

Re: Extracting values from a Gauge RR report

Looks like I need the "Make Combined Data Table" function but I haven't figured out how to make it work yet.

0 Kudos
Highlighted

Re: Extracting values from a Gauge RR report

Hi, @Mark_ON !

 

You're going to have to look at the display tree to figure out the name of the table box you want.  There are some notes on that in the scripting guide here:  https://www.jmp.com/support/help/14-2/display-box-object-references.shtml#196235

 

Here are some examples of getting bits and pieces from a report: 

http://www.jmp.com/support/help/14-2/extract-values-from-an-analysis-into-a-report.shtml 

https://community.jmp.com/t5/JSL-Cookbook/Extract-Statistics-from-an-Analysis-into-a-Report/ta-p/415...

https://community.jmp.com/t5/Discussions/How-to-extract-a-numberical-value-from-quot-Distribution-qu... (note Xan's comments at the bottom)

https://community.jmp.com/t5/Discussions/Newbie-Question-extracting-values-from-a-report/td-p/11787

 

On your other thought, Make Combined Data Table is a message that you would send to a table box.  so you still need to be able to work the display tree for the report to get to it.  

 

Hope that helps!

 

Best,

 

M

 

 

0 Kudos