cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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