Bubble Chart · ActiveUI

Example

Bubble Chart Example

Summary of settings

Type of chart: Scatter
Mapping of y attribute: Risk
Mapping of x attribute: Profit and Loss
Cardinality: Desk
Size mapped to the third measure of interest using a formula
Text mapped to Desk
Color mapped to Desk

Step-by-step instruction

Add new Chart Widget
Select Scatter
If there are multiple cubes connected to your application, you must select the cube you want for the chart.
To map the x attribute, select a measure or a formula for the horizontal axis, in this case - Profit and Loss.
Map the y attribute in the same way you mapped the x attribute, in this case to Risk.
The initial chart displays one point, the total for the measure selected on the x axis plotted against the total for the measure selected on the y axis:
If there are too many ticks on either axis, click on the axis label:

Then in the Options tab reduce the number of ticks:
Select Members you would like to display on the chart, in this case members of the dimension Desk . Click Options in the legend area of the chart:

In the Options popup you can change various attributes. In this case, map Cardinality to Desk:

The scatter displays two points, because there are two members in the Desk dimension:

To restrict data in the view, use Filters
Mouse-hover displays which point is DeskA and which point is DeskB.

You can also add labels to display relevant information next to the points:

Go to Options in the Legend again and map the attribute Text to the same dimension as Cardinality:
Finally, assign each point a size, proportional to the third measure of interest.

Size should be expressed in pixels and should be proportional to a positive measure.

In this example, link size to the measure contributors.COUNT in the cube.

The formula below is used to allocate 100 pixels to Members proportionally. Instead of 100 pixels, you may allocate a smaller or bigger number of pixels depending on space available to the chart.
```
100 * [Measures].[contributors.COUNT] / (
  [Measures].[contributors.COUNT],
  [Booking].[Desk].[ALL].[AllMember]
)
```
The expression in brackets - having defaultmember - returns total across all the members for a given measure:
```
(
  [Measures].[contributors.COUNT],
  [Booking].[Desk].[ALL].[AllMember]
)
```
To map this formula to the Size attribute, open Options popup from the Legend again and set the size as follows:

Now the visualization shows that, although it is more profitable and riskier, DeskA turns out to be smaller:

You may also map Text Color to white and Color to the Desk dimension:

The chart is complete:

Back to Legacy Chart Gallery

Appendix

The appendix contains code snippets for advanced users.

MDX:

WITH
 Member [Measures].[Size] AS 100 * [Measures].[contributors.COUNT] / (
  [Measures].[contributors.COUNT],
  [Booking].Desk.defaultmember
), FORMAT_STRING = "#,###.##"
SELECT
  NON EMPTY {
    [Measures].[Pnl],
    [Measures].[Risk],
    [Measures].[Size]
  } ON COLUMNS,
  NON EMPTY [Booking].[Desk].[Desk].Members ON ROWS
  FROM [EquityDerivativesCube]

JSON:

{
  "configurations": [
    {
      "handlers": {
        /* ... */
      },
      "type": "scatter",
      "mapping": {
        "x": {
          "from": "[Measures].[Pnl]",
          "ticks": 4
        },
        "y": {
          "from": "[Measures].[Risk]",
          "ticks": 6
        },
        "color": {
          "from": ["[Booking].[Desk].[Desk]"]
        },
        "r": {
          "from": "[Measures].[Size]"
        },
        "text": {
          "from": ["[Booking].[Desk].[Desk]"]
        },
        "textColor": {
          "value": "rgb(255, 255, 255)"
        }
      },
      "legend": {
        "display": "hidden"
      }
    }
  ]
}