topic Color by column in multiple dashboards in Discussions

Color by column in multiple dashboards

SM1956 — Sun, 11 Jun 2023 11:28:42 GMT

Hi,

I am trying to create a tabbed dashboard from the same data table, each tab is for a particular tool type. I would like to like to color the plots in each tab by that particuar tool type using "color by column". However, once the second tab uses the color by column, the previous tab's color scheme changes. Is there any way to prevent this so that the coloring scheme is for previous tab is not changed by the coloring scheme in next tab?

My code looks like (I am using JMP16.12) ---

/* ToolSet A Dashboard */
dt<<color by column(:ToolA_ID, color theme ("JMP Dark"));
...dashboard code for ToolSet A
/* ToolSet B Dashboard */
dt<<color by column(:ToolB_ID, color theme ("JMP Dark"));
...dashboard code for ToolSet B

Re: Color by column in multiple dashboards

Phil_Kay — Fri, 28 Oct 2022 10:04:04 GMT

Hi,

There are many people in this community that are better than me for answering questions about scripting.

However, I wonder if setting the color theme as a column property might prevent the problems that you are having.

Below is an example of changing a Color Gradient column property.

I hope this helps,

Phil

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

//Set Color Gradient column property for Weight to "Magma"
:weight << Set Property(
	"Color Gradient",
	{"Magma", Range( {64, 172, 105} )}
);

dt << Graph Builder(
	Size( 522, 408 ),
	Show Control Panel( 0 ),
	Variables( Y( :weight ), Color( :weight ) ),
	Elements( Points( Y, Legend( 5 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{Marker Size( 6 ), Marker Drawing Mode( "Normal" )}
		)
	)
);

Re: Color by column in multiple dashboards

SM1956 — Fri, 28 Oct 2022 16:34:47 GMT

Phil_Kay,

Thank you for your response. Graph builder preserves the color scheme but One Way analysis does not. I am enclosing a sample data table and scriptt. Once the second One Way analysis is run, colors on the first One Way analysis change, resulting in jumbled up colors for the Y by Tool 1 ID plot.

Thanks again.