BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
dale_lehman
Community Trekker

Treemaps in graph builder with filters

When I use graphbuilder to get treemaps, add a wrap variable, and add a local data filter, the colors in the treemap keep changing as I use the filter.  Is there a way to keep the colors constant as the filter is used.  The colors remain the same across the several treemaps constructed via the wrapped variable, but the keep changing as the filter is used.  I don't see any way to fix the color scheme.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Treemaps in graph builder with filters

If you set the "School Type" column property, "Value Colors" and then drag "School Type" to the Color drop area, the colors will remain set.

Jim
10 REPLIES 10
txnelson
Super User

Re: Treemaps in graph builder with filters

The issue appears to be fixed in JMP 13, but remains a problem in JMP 12
Jim
0 Kudos
dale_lehman
Community Trekker

Re: Treemaps in graph builder with filters

I am using JMP 13 and it does not appear to be fixed.  I even tried color or mark by column and adding that column into the Color box, but as I use my filter, the colors keep changing.

0 Kudos
txnelson
Super User

Re: Treemaps in graph builder with filters

can you share your data table and Graph Builder settings. The example I put together based upon my interpretation of what you are doing is apparently not getting at the issue.
Jim
0 Kudos
dale_lehman
Community Trekker

Re: Treemaps in graph builder with filters

JMP report (with embedded table) attached. I had to anonymize the data.
0 Kudos
dale_lehman
Community Trekker

Re: Treemaps in graph builder with filters

JMP report (with embedded table) attached. I had to anonymize the data.
0 Kudos
txnelson
Super User

Re: Treemaps in graph builder with filters

apparently they haven't fixed the issue with being able to attach a file once the discussion is an ongoing discussion. Could you please copy the script for your data table into the paste buffer, and then paste it into the JSL icon, and send the table that way?
Jim
0 Kudos
Highlighted
dale_lehman
Community Trekker

Re: Treemaps in graph builder with filters

Graph Builder(
	Size( 495, 488 ),
	Show Control Panel( 0 ),
	Variables( X( :school type ), Wrap( :Group ) ),
	Elements( Treemap( X, Legend( 5 ), Layout( "Squarify" ) ) ),
	Local Data Filter(
		Add Filter( columns( :StartTerm ), Where( :StartTerm == "15/FA" ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{DispatchSeg( TreeMapSeg( 1 ), Frame Size( 242, 192 ) )}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox( 2 ),
			{DispatchSeg( TreeMapSeg( 1 ), Frame Size( 241, 192 ) )}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox( 3 ),
			{DispatchSeg( TreeMapSeg( 1 ), Frame Size( 242, 192 ) )}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox( 4 ),
			{DispatchSeg( TreeMapSeg( 1 ), Frame Size( 241, 192 ) )}
		)
	)
);
0 Kudos
dale_lehman
Community Trekker

Re: Treemaps in graph builder with filters

I was able to copy the script from the Graph Builder, but not the table script.  The first error I got was that it exceeded 1 million characters, so I took a 10% random sample and got a message that it exceeed 20,000.  This is too difficult a way to attach the file.  If you send me an email address, I will send it to you.  Thanks.

0 Kudos
txnelson
Super User

Re: Treemaps in graph builder with filters

If you set the "School Type" column property, "Value Colors" and then drag "School Type" to the Color drop area, the colors will remain set.

Jim