您能否使气泡大小和颜色取决于 icCube amChart 小部件中的 MDX 度量?

问题描述

我正在尝试在 icCube 中制作一个动态图表，其中气泡根据 MDX 结果集中的特定数据字段调整大小和颜色.

示例 MDX 结果集:(为简单起见，x/y 坐标已被删除):

 数量颜色子弹大小瑞士 100 #0000FF 10西班牙 120 #FF0000 12NL 70 #00FF00 7

我现在不知道如何在 icCube 的 amChart 小部件中执行此操作，但我知道可以在 amCharts 本身中执行此操作.例如，您可以在 amCharts 编辑器中设置以下属性:

• Alpha 字段、项目符号字段、项目符号大小字段、说明字段、填充颜色字段、标签颜色字段、线条颜色字段等(有关更多信息，请参阅 amCharts 实时编辑器).

附上一个包含两个系列的示例图表，其中一个带有彩色气泡:示例

icCube 网络报告中是否可以执行此操作，如果可以，如何执行?

解决方案

是的，您可以，只需将以下内容写入额外选项"字段:

:{图表:[{xField: "your_x_field",yField: "your_y_field",值字段:金额"，bulletSizeField: "子弹尺寸",子弹:圆形"，颜色字段:颜色"}]}

请注意，上面定义的图形将被这个覆盖，您必须在此处指定所有图形设置.

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.

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

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:

• 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

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