BookmarkSubscribe
Choose Language Hide Translation Bar
bittnere
Community Trekker

Editing Color Gradient Scale Using JSL

Hi All,

 

I have this data table for example

table.PNG

 

test = Graph Builder(
	Variables( X( :X ), Y( :Y ), Color( :Value ) ),
	Elements( Points( X, Y, Legend( 23 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				23,
				Properties(
					0,
					{gradient(
						{Scale Values( [-2 2] ), Label Format( "Fixed Dec", 15, 3 )}
					)},
					Item ID( "Value", 1 )
				)
			)}
		)
	)
);

I run the above script to get this graph below with the color gradient +/-2 standard deviations. This helps to not show fliers if the data set is large.orig graph.PNG

 

In the graph below the only thing I do is right click on the color gradient and change the scale type to linear (because it's easier to think in linear scales). I'm struggling to script this step.

 

 

 

update scale.PNG

 

Note, I do not want the graph below which is just the default when making the graph before adjusting the gradient.

default.PNG

The closest I've gotten is below but it sets the scaled linearly from -2 to 2 which was what I inputted for the standard deviation limits.

test << Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				3,
				Properties(
					0,
					{gradient(
						{ Scale Values[ ], Label Format( "Fixed Dec", 15, 4 ),
						Scale Type( "Linear" )}
					)},
					Item ID( "Entry X Offset", 1 )
				)
			)}
		)

Any thoughts are much appreciated! - Evan

 

0 Kudos
4 REPLIES 4
pmroz
Super User

Re: Editing Color Gradient Scale Using JSL

Work on the graph in GB and set the scale to exactly what you want.  Then click the red triangle and select Script > Save to script window.  Here's what I got after changing the scale somewhat:

Graph Builder(
	Show Control Panel( 0 ),
	Variables( X( :X ), Y( :Y ), Color( :Value ) ),
	Elements( Points( X, Y, Legend( 9 ) ) ),
	SendToReport(
		Dispatch( {}, "400", ScaleBox,
			{Legend Model( 9,
				Properties( 0,
					{gradient( {Scale Values( [2.2 2.6 3.2] )} )},
					Item ID( "Value", 1 )
				)
			)}
		)
	)
);
bittnere
Community Trekker

Re: Editing Color Gradient Scale Using JSL

Thanks for the reply!

I don't want to have to do any manual work in Graph Builder though. The idea of my (larger) script is to automatically make many graphs with appropriate scaling for each graph and data set. To see patterns the scale needs to individually adjust for each column/set of data. There's too many to do manually.
0 Kudos
pmroz
Super User

Re: Editing Color Gradient Scale Using JSL

The point of the exercise is to see what JSL GB produces for a customized scale.  Once you have that you can programmatically determine the scaling for each dataset and substitute that into your GB JSL at runtime.  

0 Kudos
pmroz
Super User

Re: Editing Color Gradient Scale Using JSL

Here's an example where I'm dynamically determining the gradient from one of the columns.

dt = New Table( "Untitled", Add Rows( 4 ),
	New Column( "X", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [1, 2, 3, 4] )  ),
	New Column( "Y", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [4, 1, 3, 2] ) ),
	New Column( "Value", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [1, 1, 2, 2] ) )
);

dtcol = column(dt, "Y");
one_min = col min(dtcol);
one_max = col max(dtcol);
one_avg = col mean(dtcol);

scale_matrix = matrix({one_min, one_avg, one_max});

Graph Builder(
	Show Control Panel( 0 ),
	Variables( X( :X ), Y( :Y ), Color( :Value ) ),
	Elements( Points( X, Y, Legend( 9 ) ) ),
	SendToReport(
		Dispatch( {}, "400", ScaleBox,
			{Legend Model( 9,
				Properties( 0,
					{gradient( {Scale Values( scale_matrix )} )},
					Item ID( "Value", 1 )
				)
			)}
		)
	)
);