The World Statistics Day celebration continues here in the Community. We all need reliable data for sound decision making. Do you have a data source that you trust most? Head over to Discussions to tell us about it.
Choose Language Hide Translation Bar
Highlighted
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 )}))

);
));
);``````

2 REPLIES 2
Highlighted
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.

Highlighted
Staff

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

Article Labels

There are no labels assigned to this post.