nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to force heatmap to show all rows/columns even when empty?

BHarris

Is there a trick to making a heatmap show all rows even when a data filter eliminates some of them?

Consider this plot created against "Big Class.jmp":

Graph Builder(
	Size( 673, 714 ),
	Variables( X( :sex ), Y( :age ) ),
	Elements( Heatmap( X, Y, Legend( 2 ) ) ),
	Local Data Filter(
		Add Filter( columns( :height ), Where( :height >= 65.137 & :height <= 70 ) )
	)
)

If you look at this plot, you see that the row for age 13 is completely missing. I realize that the local data filter removed all entries for age 13, but is there a good way to make the row for 13 still show up, i.e. as an all-white row.

Accepted answers

jthi

Sometimes enabling Show Excluded Rows might also work. To enable Show Excluded Rows, hold shift when you click the red triangle

but this can end up showing some rows which you might not want to see (you could have excluded rows from the data table for example).

Names Default To Here(1); 

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

gb = dt << Graph Builder(
	Size(626, 662),
	Show Control Panel(0),
	Ignore Platform Preferences(1),
	Show Excluded Rows(1),
	Variables(X(:sex), Y(:age)),
	Elements(Heatmap(X, Y, Legend(2))),
	Local Data Filter(Add Filter(columns(:height), Where(:height >= 65.137)))
);

Depending on your data Shape Files can be a good idea like Jim did already suggest.

All comments

txnelson

Change the Age column from Ordinal to Continuous and you will get the complete Y axis you want

BHarris

Sadly in our case that variable truly is nominal, so that won't work for our specific problem.

txnelson

You can create a simple Shape map that contains all of the categories, and then drag your count column onto the map, and it will display a choropleth map, which is a heat map. You will have to create a new column which is a combination of your current X and Y variables, which will point to the specific element in the map, but it will do what you want.

BHarris

This sounds like it could work. I read the docs on Shape maps, but I'm not sure I'm understanding them. How do I make the map you're describing? And how do I load it?

jthi

Sometimes enabling Show Excluded Rows might also work. To enable Show Excluded Rows, hold shift when you click the red triangle

but this can end up showing some rows which you might not want to see (you could have excluded rows from the data table for example).

Names Default To Here(1); 

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

gb = dt << Graph Builder(
	Size(626, 662),
	Show Control Panel(0),
	Ignore Platform Preferences(1),
	Show Excluded Rows(1),
	Variables(X(:sex), Y(:age)),
	Elements(Heatmap(X, Y, Legend(2))),
	Local Data Filter(Add Filter(columns(:height), Where(:height >= 65.137)))
);

Depending on your data Shape Files can be a good idea like Jim did already suggest.

txnelson

Jarmo,

Your response is clearly a better choice, however, the interactive selection of

Show Excluded Rows

does not appear as an option on my list of selections

The option does appear in my preferences. Have you any idea what the issue is?

jthi

You have to be holding down SHIFT when you click on the red triangle menu (JMP does have few of these "hidden" features in red triangle menus). I have learned about it in some post by Julian such as this https://community.jmp.com/t5/Discussions/Exclude-and-Show-Data-in-Fit-Y-by-X-and-Graph-Builder/m-p/50457/highlight/true#M28685

Plot Excluded and Unhidden data points in Graph Builder