Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Make a combined table from the Distribution Platform

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 5, 2015 12:21 PM
(8518 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Sr Statistical Writer

JMP Development

6 REPLIES 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Make a combined table from the Distribution Platform

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!

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**;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Make a combined table from the Distribution Platform

Thanks Julian,

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

Very Sincerely,

Matt Goodlaw

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Sr Statistical Writer

JMP Development

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Make a combined table from the Distribution Platform

That's a much simpler solution

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Make a combined table from the Distribution Platform

Thanks Michael. Worked like a charm!

Very Sincerely,

Matt Goodlaw

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Make a combined table from the Distribution Platform

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