cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

JMP Wish List

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

Combined Data Table - refactor

What inspired this wish list request? I got into a bug(???) where if a Combined Data Table was made on a collection of plots with various Group By columns, they were lost.

Let's run this code:

Names Default To Here(1); 

dt = open("$SAMPLE_DATA/Big Class.jmp");

fg = dt << Fit Group(
	Bivariate(
		Y( :height ),
		X( :weight ),
		Group By(:age),
		Fit Line
	),
	Bivariate(
		Y( :height ),
		X( :weight ),
		Group By(:age),
		Fit Line
	),
	Bivariate(
		Y( :height ),
		X( :weight ),
		Group By(:age),
		Fit Line
	),		
	Bivariate(
		Y( :height ),
		X( :weight ),
		Group By(:sex),
		Fit Line
	),
	<<{Arrange in Rows( 4 )}
);

You'll get a Fit Group where the last Bivariate has a different Group By column (:sex instead of :age)

Then let's click on the first "Summary of Fit" and select Make Combined Data Table.

We'll see that the age column has missing values for the plot that has Group By column NOT :age, and there is no column called "sex"

Age column has missing values where Group By column is not AgeAge column has missing values where Group By column is not Age

 

What is the improvement you would like to see? 

Group By is as much of a variable in analysis as X or Y. Why don't we have separate columns for it? Group By Name and Group By Value? This will make automating further analysis much easier.

Worst case scenario, when making combined data table - just use the same logic as concatenating tables with non-matching columns - all columns get in the result with missing values where column did not present in the table.

 

 

Why is this idea important?  Having Linear Fit or other models and looking at the report is not the end of the analysis - it might be the very beginning. If we have many models, many conditions, many things to look at, robust combined data table would help to automate this

 

 

1 Comment
SarahGilyard
Staff
Status changed to: Acknowledged

Thank you for posting. We are reviewing internally.