cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use JMP Live to centralize and share reports within groups. Webinar with Q&A April 4, 2pm ET.
Choose Language Hide Translation Bar
View Original Published Thread

Missing entries - modelling type: continuous

hogi
Level XII

For nominal values there is the setting in GraphBuilder to Include Missing Categories

hogi_0-1708408303865.png

Then, instead of ignoring rows with missing values, Graph Builder will display an additional item on the axis and/or in the legend - and SHOW the entries:

hogi_1-1708408418193.png

 

If there are missing entries in a column that has continuous values - the values will not be displayed, even with Include Missing Categories enabled. Where should they?

 

As a workaround, the user could create a transform column (is missing -> 1) and display it in addition to the continuous values.

hogi_7-1708408983877.png

 

Is there an official / more straightforward / nicer solution?

 

Graph Builder(
	Transform Column(
		"missing",
		Format( "Fixed Dec", 5, 0 ),
		Formula( If( Is Missing( :height ), 1, . ) )
	),
	Size( 566, 413 ),
	Set α Level( 0.01 ),
	Summary Statistic( "Median" ),
	Graph Spacing( 4 ),
	Variables( X( :missing ), X( :height ), Y( :weight ), Overlay( :sex ) ),
	Relative Sizes( "X", [58 151] ),
	Elements(
		Position( 1, 1 ),
		Points( X, Y, Legend( 20 ) ),
		Smoother( X, Y, Legend( 23 ) )
	),
	Elements(
		Position( 2, 1 ),
		Points( X, Y, Legend( 21 ) ),
		Smoother( X, Y, Legend( 22 ) )
	)
)
1 REPLY 1
jthi
Super User


Re: Missing entries - data type: continuous

Include missing categories, continuous variables aren't categorical which is most likely the reason why they aren't show.

jthi_0-1708411376910.png

So I think your option if creating categorical column for those missing values is most likely the correct choice

-Jarmo