Missing entries - modelling type: continuous

hogi — Sun, 24 Mar 2024 12:17:43 GMT

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

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:

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.

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 ) )
	)
)

Re: Missing entries - data type: continuous

jthi — Tue, 20 Feb 2024 06:44:55 GMT

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

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

topic Re: Missing entries - data type: continuous in Discussions

Missing entries - modelling type: continuous

Re: Missing entries - data type: continuous