Subscribe Bookmark RSS Feed

Make a combined table from the Distribution Platform

mpg

Community Trekker

Joined:

Oct 5, 2014

Hello,

I am trying to make a combined table from the distriibution platform  I am using the foillowing script.

ex: using Big Class.

dist = Distribution(

Stack( 1 ),

Continuous Distribution(

Column( :weight ),

Horizontal Layout( 1 ),

Vertical( 0 ),

Set Quantile Increment( 0.01 )

),

By( :sex )

);

dr = dist << report;

tb = dr[TableBox( 1 )];

tb << Make Combined Data Table;

I receive an error in the line tb = dr[TableBox( 1 )];

Using the tree structure, looks like it could be ListBox(8); IfBox(8), OutlineBox(3) or Table Box(1).

I get the same error in all cases.

What am I doing wrong?

Thanks in advance!!

Very Sincerely,

Matt

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Hi Matt,

Try putting a [1] between dr and [Table Box(1)].

If you run just

dr = dist<<report;

and look at the log, you'll notice that dr is a list of DisplayBoxes, so you have to index into that list before you can index into one of the display boxes.

Best,

Michael

Michael Crotty
Sr Statistical Writer
JMP Development
6 REPLIES
julian

Staff

Joined:

Jun 25, 2014

Hi Matt,

I think I see what's happening here. To extract the specific component of the report, you need to include the entire display structure in the JSL call. I modified your code (included below) to pull out the combined report first for the quantiles, then for the summary statistics (I wasn't sure which you were after). Notice that we need to reference the entire tree so JMP knows which box you're referring to.  I hope this helps!

julian

dist = Distribution(

Stack( 1 ),

Continuous Distribution(

Column( :weight ),

Horizontal Layout( 1 ),

Vertical( 0 ),

Set Quantile Increment( 0.01 )

),

By( :sex )

);

reportQuantile = Report( dist[1] )[Outline Box (1)][Table Box(1)] << Make Combined Data Table;

reportSummary = Report( dist[1] )[Outline Box (1)][Table Box(2)] << Make Combined Data Table;

mpg

Community Trekker

Joined:

Oct 5, 2014

Thanks Julian,

I see a lot more with the way you laid it out.

Very Sincerely,

Matt Goodlaw

Solution

Hi Matt,

Try putting a [1] between dr and [Table Box(1)].

If you run just

dr = dist<<report;

and look at the log, you'll notice that dr is a list of DisplayBoxes, so you have to index into that list before you can index into one of the display boxes.

Best,

Michael

Michael Crotty
Sr Statistical Writer
JMP Development
julian

Staff

Joined:

Jun 25, 2014

That's a much simpler solution

julian

mpg

Community Trekker

Joined:

Oct 5, 2014

Thanks Michael.  Worked like a charm!

Very Sincerely,

Matt Goodlaw

Wendy_Murphrey

Joined:

Jun 23, 2011

JMP Sample Note 46983 also addresses this question.  You can find other sample notes by clicking on the Sample Notes link in the Knowledge Base.

Wendy