The bubbles in the bubble chart can be customized using markers tab. In the example below, Revenue(M1), Profit(M2), Profit Margin (M3) are plotted across Month. In this case we need only two metrics M1 and M2.Īttributes - 1 or more attributes are required to determine the context for the metric values. The bubble chart will also work as a scatter chart where the size of the bubbles will not vary. The first metric M1 is used for X-axis, the second metric M2 is used for Y-axis and the third metric M3 is used to determine the size of the bubble.

The size of the bubble, the color of the bubble and the location can all be used to represent information in an intuitive manner. For detailed information about the specific options for Bubble charts in MicroStrategy, see the MicroStrategy Developer help.A Bubble chart is a type of chart that displays three dimensions of data.The size of each bubble represents the third metric. If the grid contains more than three metrics on the grid, the graph may not be useful because Bubble charts are designed to plot two values (two metrics) at a time. However, to create an effective Bubble chart, it is best to avoid more than three metrics on the grid report. At least one attribute and three metrics must be present on a grid report to be able to create a Bubble chart.This analysis suggests that further analysis needs to be done to determine why shipping times were so long for this shipping point in 2009, since the number of outbound deliveries and delivery items were both relatively small. The bubble's vertical position along the Y-axis emphasizes that the Dallas, TX shipping point for 2009 shipped fewer than 20 outbound items for all outbound deliveries. Its placement along the X-axis informs you that the Dallas, TX shipping point for 2009 had fewer than 10 outbound deliveries. Notice that the largest bubble in the graph is the one for the 2009 Dallas, TX this shows that the average delivery time was the largest for the Dallas, TX shipping point during the year 2009. The third metric placed in the columns determines the size of each bubble. A third metric, Average Total Delivery Time for Outbound Deliveries (Days), is included as the third metric on the columns of the grid report. The Y-axis represents the Outbound Delivery Items metric. The X-axis represents the Outbound Deliveries metric, which displays the number of outbound deliveries. The size of each bubble represents that shipping point's average total delivery time for outbound items. In the graph, a colored bubble is designated for each shipping point for the years 20. The graph below provides an example of how three metrics are displayed within a Bubble chart.

You can create the following types of Bubble charts in MicroStrategy:

The third metric on the grid determines the size of each bubble.

The second metric on the grid determines what is placed on the Y-axis.The first metric on the grid determines what is placed on the X-axis.Where you place each object on the report grid affects how that object is displayed in the resulting graph, as follows: To create a Bubble chart, you must include at least one attribute and three metrics on your report grid. A Bubble chart is a Scatter plot that also displays the size of each data marker, using bubbles to represent the different sizes of data markers.