[脚本] 颜色渐变输出R1=(dt<< 制表(
显示控制面板( 0 ),
显示工具提示( 1 ),
添加表（
列表（统计（N）），
列表( 分组列( :Name( "TEST" ) ), 统计( 行 %, N )),
行表（分组列（：半径））
）
)) << 制作成数据表;
R1:"N(1)"<< 设置属性( "颜色渐变", {"白到橙", Range( {0, 547, 187.945945945946} )} )
<< 按值对单元格着色；
R1:"N(8)"<< 设置属性( "颜色渐变", {"白到橙", Range( {0, 547, 187.945945945946} )} )
<< 按值对单元格着色；
R1:"N(9)"<< 设置属性( "颜色渐变", {"白到橙", Range( {0, 547, 187.945945945946} )} )
<< 按值对单元格着色；
上面脚本的输出被组合在一起。 因此，为 N(1)、N(8)、N(9) 设置的颜色梯度已组合，我如何分离每个 N(s) 以拥有自己的特定颜色梯度
回复：[脚本]颜色渐变输出嗨，是的，这就是我试图解决的问题。 非常感谢您的帮助和指导。 抱歉我的英语不好。 谢谢
回复：[脚本]颜色渐变输出该脚本失败，因为没有定义名为：
从零到三 3
日志出现以下错误
Scoped data table access requires a data table column or variable in access or evaluation of 'dt:zero to three 3' , dt:zero to three 3/*###*/
这可以通过多种方式处理。 如果您想继续使用“硬编码”，您可以使用“尝试”功能解决该问题：
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
dt << New Column( "zero to three", formula( Random Integer( 0, 3 ) ) );
dt << New Column( "zero to three 2", formula( Random Integer( 0, 3 ) ) );
dt << New Column( "zero to three 4", formula( Random Integer( 0, 3 ) ) );
Try( dt:zero to three << Set Property( "Color Gradient", {"White to Orange"} ) << Color Cell by Value );
Try( dt:zero to three 2 << Set Property( "Color Gradient", {"White to Orange"} ) << Color Cell by Value );
Try( dt:zero to three 3 << Set Property( "Color Gradient", {"White to Orange"} ) << Color Cell by Value );
Try( dt:zero to three 4 << Set Property( "Color Gradient", {"White to Orange"} ) << Color Cell by Value );
或者，您可以更高级一点，看看哪些名称与您想要的模式匹配，如果匹配，则应用颜色渐变：
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
dt << New Column( "zero to three", formula( Random Integer( 0, 3 ) ) );
dt << New Column( "zero to three 2", formula( Random Integer( 0, 3 ) ) );
dt << New Column( "zero to three 4", formula( Random Integer( 0, 3 ) ) );
ColNames = dt << get column names( string, numeric );
For( i = 1, i <= N Items( ColNames ), i++,
If( Contains( Uppercase( ColNames[i] ), "ZERO TO THREE" ) == 1,
Column( dt, ColNames[i] ) << Set Property( "Color Gradient", {"White to Orange"} ) << Color Cell by Value
)
);
这是您正在努力解决的问题吗？
回复：[脚本]颜色渐变输出好的，我已经明白我的脚本的问题了。 尝试运行这个。
<SPAN class="token function">Names default to here</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token number">1</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
dt<SPAN class="token operator">=</SPAN><SPAN class="token function">open</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token string">"$SAMPLE_DATA\big class.jmp"</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
dt<SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN><SPAN class="token function">new column</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token string">"zero to three"</SPAN><SPAN class="token punctuation">,</SPAN> formula<SPAN class="token punctuation">(</SPAN><SPAN class="token function">random integer</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token number">0</SPAN><SPAN class="token punctuation">,</SPAN><SPAN class="token number">3</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
dt<SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN><SPAN class="token function">new column</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token string">"zero to three 2"</SPAN><SPAN class="token punctuation">,</SPAN> formula<SPAN class="token punctuation">(</SPAN><SPAN class="token function">random integer</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token number">0</SPAN><SPAN class="token punctuation">,</SPAN><SPAN class="token number">3</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;<BR /></SPAN>dt<<NEW column="">:zero to three <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Set Property<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Color Gradient"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token string">"White to Orange"</SPAN><SPAN class="token punctuation">}</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Color Cell by Value<SPAN class="token punctuation">;</SPAN>
dt<SPAN class="token punctuation">:</SPAN>zero to three <SPAN class="token number">2</SPAN> <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Set Property<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Color Gradient"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token punctuation">{</SPAN><SPAN class="token string">"White to Orange"</SPAN><SPAN class="token punctuation">}</SPAN><SPAN class="token punctuation">)</SPAN> <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN> Color Cell by Value<SPAN class="token punctuation">;<BR />dt:zero to three 3 << Set Property( "Color Gradient", {"White to Orange"}) << Color Cell by Value;<BR />dt:zero to three 4 << Set Property( "Color Gradient", {"White to Orange"}) << Color Cell by Value</SPAN></NEW>
回复：[脚本]颜色渐变输出我一定错过了一些东西，因为颜色渐变，以及你可以控制的指定范围。 所以我不明白为什么颜色没有按照您的意愿设置存在问题。 下面是让 JMP 设置颜色并评估值范围的示例，以及设置值的第二个示例。
这些值可以通过计算列平均值或任何您想要的方法来设置
Names default to here(1);
dt=open("$SAMPLE_DATA\big class.jmp");
dt<<NEW column=""></NEW>
现在，如果您想为特定单元格显式设置颜色，那么您可以这样做。
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
:Age << Color Cells( "Red",5 );
回复：[脚本]颜色渐变输出
This is run with the given scriptThis is run with the given script这是使用给定脚本运行的
This is the type colour gradient that i am talking aboutThis is the type colour gradient that i am talking about这就是我所说的颜色渐变类型
我想要图2的输出
回复：[脚本]颜色渐变输出您能否解释一下为什么超过 99 列会受到限制？ 我不明白你的评论。
回复：[脚本]颜色渐变输出你好，
好吧，我就是这样做的，但是随着数据大小增加到 N(99)，所有列都不会应用颜色模式。
还有其他方法来应用颜色图案吗？
回复：[脚本]颜色渐变输出我希望这就是您所要求的。
要更改颜色图案，您所要做的就是更改渐变图案和/或颜色范围。 下面我选取了第一列 N(1) 并更改了它的梯度
R1:"N(1)" << Set Property( "Color Gradient", {"Blue to Green to Red", Range( {31, 284, 150} )} ) << Color Cell by Value;
R1:"N(8)" << Set Property( "Color Gradient", {"White to Orange", Range( {0, 547, 187.945945945946} )} ) << Color Cell by Value;
R1:"N(9)" << Set Property( "Color Gradient", {"White to Orange", Range( {0, 547, 187.945945945946} )} ) << Color Cell by Value;回复：[脚本]颜色渐变输出您好，附件是R1数据表
回复：[脚本]颜色渐变输出能提供一下R1的数据表吗？
