Subscribe Bookmark RSS Feed

Treemaps in graph builder with filters

dale_lehman

Community Trekker

Joined:

Jan 29, 2015

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.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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
txnelson

Super User

Joined:

Jun 22, 2012

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

Community Trekker

Joined:

Jan 29, 2015

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.

txnelson

Super User

Joined:

Jun 22, 2012

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
dale_lehman

Community Trekker

Joined:

Jan 29, 2015

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

Community Trekker

Joined:

Jan 29, 2015

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

Super User

Joined:

Jun 22, 2012

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
dale_lehman

Community Trekker

Joined:

Jan 29, 2015

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 ) )}
		)
	)
);
dale_lehman

Community Trekker

Joined:

Jan 29, 2015

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.

txnelson

Super User

Joined:

Jun 22, 2012

Solution

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