Highlighted
Level II

## Plot two different datasets with different specs

I need help to make a data plot like shown below using JMP GUI preferred, if not then scripting is fine. The red dataset has the orange lines LSL/Target/USL specs whereas the blue datasets has blue lines LSL/Target/USL specs.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: Plot two different datasets with different specs

You would have to do something like this:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" ); Wait( 0 ); dt2 = dt << subset( selected columns( 0 ), selected rows( 0 ) ); dt:Height << set property( "Spec Limits", { LSL( 55 ), Target( 62 ),USL( 68 )} ); dt2:Height << set property( "Spec Limits", { LSL( 56 ),Target( 63 ), USL( 69 )} ); dt:Weight << set property( "Spec Limits", { LSL( 85 ),Target( 105 ), USL( 145 )} ); dt2:Weight << set property( "Spec Limits", { LSL( 86 ),Target( 106 ), USL( 146 )} ); biv = Bivariate( Y( :height ), X( :weight ) ); Report( biv )[axis box( 1 )] << add ref line( ((dt:Height << get property( "spec limits" ))["LSL"]), "solid", blue ); Report( biv )[axis box( 1 )] << add ref line( ((dt:Height << get property( "spec limits" ))["USL"]), "solid", blue ); Report( biv )[axis box( 1 )] << add ref line( ((dt:Height << get property( "spec limits" ))["Target"]), "solid", blue ); Report( biv )[axis box( 1 )] << add ref line( ((dt2:Height << get property( "spec limits" ))["LSL"]), "solid", blue ); Report( biv )[axis box( 1 )] << add ref line( ((dt2:Height << get property( "spec limits" ))["USL"]), "solid", blue ); Report( biv )[axis box( 1 )] << add ref line( ((dt2:Height << get property( "spec limits" ))["Target"]), "solid", blue ); Report( biv )[axis box( 2 )] << add ref line( ((dt:Weight << get property( "spec limits" ))["LSL"]), "solid", red ); Report( biv )[axis box( 2 )] << add ref line( ((dt:Weight << get property( "spec limits" ))["USL"]), "solid", red ); Report( biv )[axis box( 2 )] << add ref line( ((dt:Weight << get property( "spec limits" ))["Target"]), "solid", red ); Report( biv )[axis box( 2 )] << add ref line( ((dt2:Weight << get property( "spec limits" ))["LSL"]), "solid", red ); Report( biv )[axis box( 2 )] << add ref line( ((dt2:Weight << get property( "spec limits" ))["USL"]), "solid", red ); Report( biv )[axis box( 2 )] << add ref line( ((dt2:Weight << get property( "spec limits" ))["Target"]), "solid", red );  You could specify the "Show Limits(1)" element of the Spec Limits property, but one will still need to create the "Add Ref Line" for the second data table. Jim 2 REPLIES 2 Highlighted Super User ## Re: Plot two different datasets with different specs You would have to do something like this: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA\big class.jmp" );
Wait( 0 );
dt2 = dt << subset( selected columns( 0 ), selected rows( 0 ) );

dt:Height << set property( "Spec Limits", { LSL( 55 ), Target( 62 ),USL( 68 )} );
dt2:Height << set property( "Spec Limits", { LSL( 56 ),Target( 63 ), USL( 69 )} );

dt:Weight << set property( "Spec Limits", { LSL( 85 ),Target( 105 ), USL( 145 )} );
dt2:Weight << set property( "Spec Limits", { LSL( 86 ),Target( 106 ), USL( 146 )} );

biv = Bivariate( Y( :height ), X( :weight ) );

Report( biv )[axis box( 1 )] << add ref line( ((dt:Height << get property( "spec limits" ))["LSL"]), "solid", blue );
Report( biv )[axis box( 1 )] << add ref line( ((dt:Height << get property( "spec limits" ))["USL"]), "solid", blue );
Report( biv )[axis box( 1 )] << add ref line( ((dt:Height << get property( "spec limits" ))["Target"]), "solid", blue );

Report( biv )[axis box( 1 )] << add ref line( ((dt2:Height << get property( "spec limits" ))["LSL"]), "solid", blue );
Report( biv )[axis box( 1 )] << add ref line( ((dt2:Height << get property( "spec limits" ))["USL"]), "solid", blue );
Report( biv )[axis box( 1 )] << add ref line( ((dt2:Height << get property( "spec limits" ))["Target"]), "solid", blue );

Report( biv )[axis box( 2 )] << add ref line( ((dt:Weight << get property( "spec limits" ))["LSL"]), "solid", red );
Report( biv )[axis box( 2 )] << add ref line( ((dt:Weight << get property( "spec limits" ))["USL"]), "solid", red );
Report( biv )[axis box( 2 )] << add ref line( ((dt:Weight << get property( "spec limits" ))["Target"]), "solid", red );

Report( biv )[axis box( 2 )] << add ref line( ((dt2:Weight << get property( "spec limits" ))["LSL"]), "solid", red );
Report( biv )[axis box( 2 )] << add ref line( ((dt2:Weight << get property( "spec limits" ))["USL"]), "solid", red );
Report( biv )[axis box( 2 )] << add ref line( ((dt2:Weight << get property( "spec limits" ))["Target"]), "solid", red );


You could specify the "Show Limits(1)" element of the Spec Limits property, but one will still need to create the "Add Ref Line" for the second data table.

Jim
Highlighted
Level II

## Re: Plot two different datasets with different specs

Thank you so much for your help. I appreciate it

Article Labels

There are no labels assigned to this post.