cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
aravindan880
Level I

How to combine reports from two attribute charts into one report?

I Have generated two Attribute charts using the following codes

Attribute Chart(

  Y( :Part ),

  X( :Attribute GRR Part ),

  Standard( :Standard ),

  Effectiveness Report( 1 ),

Attribute Chart(

  Y( :Kappa Results ),

  X( :Kappa Parts ),

  Standard( :Kappa Standard ),

  Effectiveness Report( 1 ),

  Attribute Gauge Chart( 0 )

);

In each chart there is some report which i want to extract

First chart                                                                  Second chart

11753_pastedImage_2.png  11754_pastedImage_7.png

I want to extract the Effectivenss Report and comformance report from the first chart and the effectiveness report from the second chart and combine in one  Data table.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to combine reports from two attribute charts into one report?

Here is a script that produces the following output:

11782_pastedImage_2.png

Names Default To Here( 1 );

dt = Current Data Table();

att1 = dt << Attribute Chart(

      Y( :Part ),

      X( :Attribute GRR Part ),

      Standard( :Standard ),

      Effectiveness Report( 1 )

);

att2 = dt << Attribute Chart(

      Y( :Kappa Results ),

      X( :Kappa Parts ),

      Standard( :Kappa Standard ),

      Effectiveness Report( 1 ),

      Attribute Gauge Chart( 0 )

);

Results List 1 = {};

Results List 1[1] = (Report( att1 )["Effectiveness"][1][1][2] << get)[1] / 100;

Results List 1[2] = (Report( att1 )["Conformance Report"][1][1][1][2] << get)[1];

Results List 1[3] = (Report( att1 )["Conformance Report"][1][1][1][3] << get)[1];

Results List 2 = {};

Results List 2[1] = (Report( att2 )["Effectiveness"][1][1][2] << get)[1] / 100;

New Window( "test",

      tb1 = Table Box(

            String Col Box( "GRR", {"Effectiveness", "False Alarm", "Miss Rate"} ),

            nb1 = Number Col Box( "Results", Results List 1 )

      ),

      tb2 = Table Box(

            String Col Box( "Kappa", {"Effectiveness"} ),

            nb2 = Number Col Box( "Results", Results List 2 )

      )

);

tb1 << set column borders( 1 ) << set row borders( 1 );

tb2 << set column borders( 1 ) << set row borders( 1 );

nb1 << set format( "Percent", 7, 2 );

nb2 << set format( "Percent", 7, 2 );



what I don't know is if the two attribute platform runs are both run on the same data table or on separate tables.  If they are on separate tables, you will need to add a second pointer to the second table, and change the reference to it where required in the script, so that the attribute platform is run against it.


Your request about putting the results into a data table can not be accommodated.  Columns in a JMP data table can not contain numeric and character data.  Your sample has a second column that has both the Character value of "Results" and also numeric values.  A JMP data table is an analysis data structure, not just a spreadsheet like Excel, where every Cell is an independent structure.


If you look at the output that I am giving you, it is also broken into 2 separate Table Boxes, but displayed together.  It was done this way, for the same reason as the data table requirement..

Jim

View solution in original post

4 REPLIES 4
txnelson
Super User

Re: How to combine reports from two attribute charts into one report?

Here is a script that will take the components you specified, and place them into a new display window.  You specified you want to combine them into one "Data Table".  Could you please give more details on what this request really is?

att1=Attribute Chart(

  Y( :Part ),

  X( :Attribute GRR Part ),

  Standard( :Standard ),

  Effectiveness Report( 1 );

att2=Attribute Chart(

  Y( :Kappa Results ),

  X( :Kappa Parts ),

  Standard( :Kappa Standard ),

  Effectiveness Report( 1 ),

  Attribute Gauge Chart( 0 )

);

nw=new window("combined",

      vlb=v list box()

);

vlb<<append(report(att1)["Effectiveness"]);

vlb<<append(report(att1)["Conformance Report"]);

report(att2)["Effectiveness"]<<set title("Effectiveness 2");

vlb<<append(report(att1)["Effectiveness 2"]);

Jim
aravindan880
Level I

Re: How to combine reports from two attribute charts into one report?

Hi nelson

I basically want to extract the effectivenss report from chart 1 and chart 2 and display it in one datatable or a summary

I want to extract the Effectiveness report , conformance report from chart 1, and Kappa effectiveness report from chart 2 and form a summary table

just to show the results summary only. this will be used for our report.

11781_pastedImage_1.png

txnelson
Super User

Re: How to combine reports from two attribute charts into one report?

Here is a script that produces the following output:

11782_pastedImage_2.png

Names Default To Here( 1 );

dt = Current Data Table();

att1 = dt << Attribute Chart(

      Y( :Part ),

      X( :Attribute GRR Part ),

      Standard( :Standard ),

      Effectiveness Report( 1 )

);

att2 = dt << Attribute Chart(

      Y( :Kappa Results ),

      X( :Kappa Parts ),

      Standard( :Kappa Standard ),

      Effectiveness Report( 1 ),

      Attribute Gauge Chart( 0 )

);

Results List 1 = {};

Results List 1[1] = (Report( att1 )["Effectiveness"][1][1][2] << get)[1] / 100;

Results List 1[2] = (Report( att1 )["Conformance Report"][1][1][1][2] << get)[1];

Results List 1[3] = (Report( att1 )["Conformance Report"][1][1][1][3] << get)[1];

Results List 2 = {};

Results List 2[1] = (Report( att2 )["Effectiveness"][1][1][2] << get)[1] / 100;

New Window( "test",

      tb1 = Table Box(

            String Col Box( "GRR", {"Effectiveness", "False Alarm", "Miss Rate"} ),

            nb1 = Number Col Box( "Results", Results List 1 )

      ),

      tb2 = Table Box(

            String Col Box( "Kappa", {"Effectiveness"} ),

            nb2 = Number Col Box( "Results", Results List 2 )

      )

);

tb1 << set column borders( 1 ) << set row borders( 1 );

tb2 << set column borders( 1 ) << set row borders( 1 );

nb1 << set format( "Percent", 7, 2 );

nb2 << set format( "Percent", 7, 2 );



what I don't know is if the two attribute platform runs are both run on the same data table or on separate tables.  If they are on separate tables, you will need to add a second pointer to the second table, and change the reference to it where required in the script, so that the attribute platform is run against it.


Your request about putting the results into a data table can not be accommodated.  Columns in a JMP data table can not contain numeric and character data.  Your sample has a second column that has both the Character value of "Results" and also numeric values.  A JMP data table is an analysis data structure, not just a spreadsheet like Excel, where every Cell is an independent structure.


If you look at the output that I am giving you, it is also broken into 2 separate Table Boxes, but displayed together.  It was done this way, for the same reason as the data table requirement..

Jim
aravindan880
Level I

Re: How to combine reports from two attribute charts into one report?

Thanks Jim

The script works like fine. It was a great help!!