cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
vince_faller
Super User (Alumni)

Exclude Grouping values in nested groups in graph builder.

I have a heat map that needs some nested groups (in order to properly show values inside the heat map) squares.  My issue is that a lot of the rows are entirely missing because it forces every group to exist.  Is there a way to only show valid groups?  For example:

 

Names Default to here(1);
dt = open("$SAMPLE_DATA\Big Class.jmp");

rows = dt << Get Rows Where(:age == 14 & :sex == "M");
dt << delete rows(rows);

dt << Graph Builder(
	Variables( Group Y( :sex ), Group Y( :age ), Color( :height ) ),
	Elements( Heatmap( Legend( 4 ) ), Caption Box( Legend( 5 ) ) )
);

Gives. 

 

3-14-2017 4-26-44 PM.png

 

I don't want to see the 14 year old Male category.  

 

Or, if you know a better way to show the means for a column inside the square, I'd take that too. 

 

 

 

Vince Faller - Predictum
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Exclude Grouping values in nested groups in graph builder.

If you have JMP 14, heatmap now has a labeling capability. You may not need to use groups:Heatmap with LabelsHeatmap with Labels

 

View solution in original post

6 REPLIES 6

Re: Exclude Grouping values in nested groups in graph builder.

Would labeled bars work?

dt << Graph Builder(
	Size( 456, 413 ),
	Show Control Panel( 0 ),
	Variables( X( :height ), Y( :sex ), Y( :age, Position( 1 ) ), Color( :height ) ),
	Elements( Bar( X, Y( 1 ), Y( 2 ), Legend( 5 ), Label( "Label by Value" ) ) ),
	SendToReport( Dispatch( {}, "sex", ScaleBox, {Reversed Scale} ) )
);

LabeledNestedBars.PNG

 

vince_faller
Super User (Alumni)

Re: Exclude Grouping values in nested groups in graph builder.

No because in actuality it's a 2d array.  More like this.  

 

3-24-2017 10-56-15 AM.png

Vince Faller - Predictum
vince_faller
Super User (Alumni)

Re: Exclude Grouping values in nested groups in graph builder.

Going to Bump this because it has come up again.  Anyone have thoughts on a good way to do this?

Vince Faller - Predictum

Re: Exclude Grouping values in nested groups in graph builder.

If you have JMP 14, heatmap now has a labeling capability. You may not need to use groups:Heatmap with LabelsHeatmap with Labels

 

vince_faller
Super User (Alumni)

Re: Exclude Grouping values in nested groups in graph builder.

Awesome! Now I just have to convince them to upgrade.  :p 

More than appreciated John, 

V

Vince Faller - Predictum

Re: Exclude Grouping values in nested groups in graph builder.

You may find some convincing material here: Explore These New Features in JMP® 14