cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Tabulate - Make into (single!) data table

☐ cool new feature
☐ could help many users!

☐ removes a bug

☑ nice to have

☐ nobody needs it

 

What inspired this wish list request? 

Analyze/Tabulate allows a user to do a trick that is not possible with Tables/Summary or JSL/Summarize.

 

it's no magic - but it's suuuper useful:    stacking of different "tables" - like here the analysis split by age and sex:

hogi_2-1732201613404.png

 

there is even a possibility to export this "collection" as a real data table via Make Into Data Table:

hogi_1-1732201093850.png

 

oh no, almost -  JMP exports every part as a separate table, so actually  it's a Make into multiple Data Tables.
This approach definitely makes sense, the structures of the individual parts might differ

- then it doesn't make sense to combine everything into one table.

On the other hand, there ARE cases where a combined data table makes sense ...

 

What is the improvement you would like to see? 

For Analyze/Tabulate please provide a functionality Make into SINGLE data table

which generates a table:

hogi_7-1732203173358.png

To make sure that no information is lost, the differences between the tables should be added as a separate column

(here: with the entries age and sex). 

 

 

 

Why is this idea important? 

The structure is already visible after generating the Tabulate report - 
with the possibility to directly combine the results into one data table the user doesn't need to:
- concatenate the different data tables - leading to too many "labelling column"
- stack the different labelling columns - leding to rows with empty labels

- get rid of of rows with empty labels

... saving him/her from some additional issues on the way:

hogi_5-1732202957627.png

 

 

other wishes from hogi_2-1702196401638.png

1 Comment
Status changed to: Acknowledged

Thank you for sharing your feedback!