cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

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!