问题描述
我正在尝试在icCube中制作一个动态图表,其中气泡的大小和颜色要根据MDX结果集中的特定数据字段来确定.
I am trying to make a dynamic chart in icCube, in which bubbles are sized and colored in accordance with a specific data field in the MDX result set.
MDX结果集示例:(为简单起见,已删除了x/y坐标):
Example MDX result set:(the x/y coordinates have been removed for the sake of simplicity):
amount color bullet size
Swiss 100 #0000FF 10
Spain 120 #FF0000 12
NL 70 #00FF00 7
我现在不知道如何在icCube的amChart小部件中执行此操作,但是我知道可以在amCharts本身中执行此操作.例如,您可以在amCharts编辑器中设置以下属性:
I do not know how to do this now in the amChart widget in icCube, but I know it is possible to do this in amCharts itself. You can set for example the following attributes in the amCharts editor:
- 字母"字段,项目符号"字段,项目符号大小"字段,描述"字段,填充颜色"字段,标签"颜色字段,线条"颜色字段等...(请参阅amCharts live编辑器中的更多信息).
- Alpha field, Bullet field, Bullet size field, Description field, Fill colors field, Label color field, Line color field, ... etc (see for more in the amCharts live editor).
附上两个系列的示例图表,其中一个带有彩色气泡:示例
Enclosed a sample chart with two series, in which one has colored bubbles:example
在icCube Web报表中是否可以做到这一点?如果可以,怎么办?
Is it possible in icCube web reporting to do this, and if so, how?
推荐答案
是的,您只需在其他选项"字段中输入以下内容即可:
Yes you can, just you have to write the following into the "Extra Options" field:
:{
graphs:[{
xField: "your_x_field",
yField: "your_y_field",
valueField: "amount",
bulletSizeField: "bullet size",
bullet : "round",
colorField: "color"
}]
}
请注意,上面定义的图形将被该图形覆盖,您必须在此处指定所有图形设置.
Note that, your graphs defined above will be overwritten by this one, you have to specify here all the graph settings.
这篇关于能否使气泡大小和颜色取决于icCube amChart小部件中的MDX度量?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!