Subscribe Bookmark RSS Feed

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

aravindan880

Community Trekker

Joined:

Apr 5, 2016

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

Joined:

Jun 22, 2012

Solution

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
4 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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

Community Trekker

Joined:

Apr 5, 2016

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

Joined:

Jun 22, 2012

Solution

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

Community Trekker

Joined:

Apr 5, 2016

Thanks Jim

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