cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Due to the recently reported Microsoft outage, users may be temporarily unable to access My JMP or experience a delay receiving their verification codes. If you have previously installed JMP on your computer, this outage should not impact your ability to access the software. My JMP services will be restored as soon as Microsoft resolves this issue.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

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
Sarah-Sylvestre
Level V
Status changed to: Acknowledged

Thank you for sharing your feedback!