cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
hogi
Level XII

Graph Builder - parallel Plot - missing entries

It is great that Graph Builder allows you to display multiple nominal values in parallel along an axis, either with points or via the parallel plot.

hogi_0-1731700938425.pnghogi_1-1731700957289.png

 

Please try Enhanced Sankey Plot (ESP)  , provided by @jthi .

This type of plot is useful to visualize correlations and root causes in the data.

 

Unfortunately, if some of the entries have missing data, it's hard to distinguish between real "splits" - and accidental splits (missing vs. available data). This problem could be solved by increasing the transparency for missing data. Unfortunately, the only way I know how to selectively add transparency is: via the color dropzone. But due to the way the data is displayed in parallel, this is a dead end:

hogi_2-1731701258940.png

 

How can I generate a plot like this:

hogi_0-1731701930267.png

 


... or is there another, better  way to mark missing data?

 

dt = Open( "$SAMPLE_DATA/Hair Care Product.jmp" ); 
for each({i},{1,3,6,8},
rows=associative array(J(1,50000,Random Integer(120000))) << get keys; 
dt [rows,i] =J(n items(rows),1,.);
);

rows = dt << get rows where(contains(:Residence,"Rural"));

dt [rows,"Residence"] =J(n items(rows),1,.);

Graph Builder(
	Summary Statistic( "Median" ),
	Graph Spacing( 4 ),
	Variables(
		X( :Promotion ),
		X( :Purchase, Position( 1 ) ),
		X( :Gender, Position( 1 ) ),
		X( :Hair Color, Position( 1 ) ),
		X( :U.S. Region, Position( 1 ) ),
		X( :Residence, Position( 1 ) ),
		X( :Validation, Position( 1 ) )
	),
	Elements( Points( X( 1 ), X( 2 ), X( 3 ), X( 4 ), X( 5 ), X( 6 ), X( 7 )) )
);

 

3 REPLIES 3
jthi
Super User

Re: Graph Builder - parallel Plot - missing entries

Maybe one option is to enable

jthi_0-1731702904813.png

 

-Jarmo
hogi
Level XII

Re: Graph Builder - parallel Plot - missing entries

?

hogi
Level XII

Re: Graph Builder - parallel Plot - missing entries

You mean "disable" - hide completely, instead of adding some transparency?
Agree, better than showing ...