能否使气泡大小和颜色取决于icCube amChart小部件中的MDX度量? [英] Can you make the bubble size and color dependend on a MDX measure in icCube amChart widget?

问题描述

我正在尝试在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度量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！