turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- JSL- New Table() assistance needed.

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
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 5, 2015 4:28 PM
(2977 views)

Hi there,

I'm trying to create a table to show my analysis. This is what I'm trying:

quantityBulbsShipped = 0;

quantityLensesShipped = 0;

Current Data Table(dtBulbsOnly);

Summarize(quantityBulbsShipped = Sum(:qtyOrdered));

Current Data Table(dtLensesOnly);

Summarize(quantityLensesShipped = Sum(:qtyOrdered));

dtSolution = New Table("Percentage of bulbs shipped with lens",

Add Row(1),

New Column("Quantity bulbs shipped", "Continuous", Set Values(quantityBulbsShipped)),

New Column"Quantity Lenses Shipped", "Continuous", Set Values(quantityLensesShipped)),

New Column("% bulbs shipped with lenses", "Continuous", Set Values(quantityLensesShipped *100.0 / quantityBulbsShipped)));

ERROR: basically there is an issue with me using variables in the above Set Values() function inside the New Table() function.

Does anyone know how to get this to work or make a similarly simple output window?

Thank you a lot!

-Loysius

1 ACCEPTED SOLUTION

Accepted Solutions

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

Jun 6, 2015 12:53 PM
(5101 views)

I think Set Values() requires a list (or matrix) argument.

Try:

Set Values**(** **{**quantityBulbsShipped**}** **)**

or

Set Values**(** list**(**quantityBulbsShipped**)** **)**

2 REPLIES

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

Jun 6, 2015 12:53 PM
(5102 views)

I think Set Values() requires a list (or matrix) argument.

Try:

Set Values**(** **{**quantityBulbsShipped**}** **)**

or

Set Values**(** list**(**quantityBulbsShipped**)** **)**

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

Jun 6, 2015 1:40 PM
(2855 views)

Thank you very much for the response. Yup, both of your solutions work. You're awesome