[Script] How to add in colour gradient

kuanaunwei

Hi, 

 

I am stuck here, i want to format my column with colour gradient. However, with the script below there is still no colour gradient applied on my column "N". Thanks

 

 

 

 

R1=(dt<< Tabulate(
Show Control Panel( 0 ),
Show Tooltip( 1 ),
Add Table(
Column Table( Statistics( N )),
Column Table( Grouping Columns( :Name( "test@7721" ) ), Statistics( Row %, N )),
Row Table( Grouping Columns( :Radius ) )
)
)) << Make Into Data Table;

R1<<Column (
"N",
Set Property("Color Gradient",{"Blue to Green to Red", Range( {0, 547, 187.945945945946})}),
Color Cell by Value
);

txnelson

The "Color Cell by Value" is a separate message and therefore needs to be handled not as part of the Color Gradient property.

R1 = (dt << Tabulate(
	Show Control Panel( 0 ),
	Show Tooltip( 1 ),
	Add Table(
		Column Table( Statistics( N ) ),
		Column Table( Grouping Columns( :Name( "test@7721" ) ), Statistics( Row %, N ) ),
		Row Table( Grouping Columns( :Radius ) )
	)
)) << Make Into Data Table;
R1:N << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {0, 547, 187.945945945946} )} ) 
     << Color Cell by Value;