nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Make a combined table from the Distribution Platform

mpg

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

Accepted answers

michael_jmp

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

All comments

jules

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;

michael_jmp

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

jules

That's a much simpler solution

julian

mpg

Thanks Michael. Worked like a charm!

Very Sincerely,

Matt Goodlaw

mpg

Thanks Julian,

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

Very Sincerely,

Matt Goodlaw

Wendy_Murphrey

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.