Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
Level II

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 ),
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
);

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User

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 ),
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;``````
Jim
Highlighted
Staff

Here's one way:

``````NamesDefaultToHere(1);

dt = NewTable("Test", << addMultipleColumns("N", 20, Numeric));

Wait(3);
cols = dt << getColumnNames("String");
for(c=1, c<=NItems(cols), c++,
Column(dt, cols[c]) << Formula(RandomNormal());
);

Wait(3);
for(c=1, c<=NItems(cols), c++,
Column(dt, cols[c]) << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {0, 547, 188} )} ) << Color Cell by Value;
);``````
5 REPLIES 5
Highlighted
Super User

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 ),
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;``````
Jim
Highlighted
Level II

Hi txnelson,
I never thought of that. Thanks a lot for the information. You've been a very big help
Highlighted
Level II

Hi, another question:

Currently i have 20 "N"s, is there a way to modify the script so that i would not need to change 20 times of the "N"

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

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

``````R1:N2 << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {0, 547, 187.945945945946} )} )
<< Color Cell by Value;``````
``````R1:N3 << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {0, 547, 187.945945945946} )} )
<< Color Cell by Value;``````
`` ``
Highlighted
Staff

Here's one way:

``````NamesDefaultToHere(1);

dt = NewTable("Test", << addMultipleColumns("N", 20, Numeric));

Wait(3);
cols = dt << getColumnNames("String");
for(c=1, c<=NItems(cols), c++,
Column(dt, cols[c]) << Formula(RandomNormal());
);

Wait(3);
for(c=1, c<=NItems(cols), c++,
Column(dt, cols[c]) << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {0, 547, 188} )} ) << Color Cell by Value;
);``````
Highlighted
Staff