Cloudera Docs

Packed bubbles

CDP Data Visualization enables you to create Packed Bubbles visuals.

Packed Bubbles visuals compare the relative values in close physical proximity. Two main series of data are used: the field on the Dimensions shelf names the bubble and the field on the Measures shelf determines the relative area of the bubble.

This is different from the traditional approach, where bubbles represent three dimensions of data — one each for horizontal and vertical axes, and one for the area of bubble. This type of visualization is part of flexibility built into Scatter visuals available in CDP Data Visualization.

The following steps demonstrate how to create a new Packed Bubbles visual on the World Life Expectancy dataset [data source samples.world_life_expectancy]. For an overview of shelves that specify this visual, see Shelves for packed bubbles visuals.

  1. Start a new visual based on the World Life Expectancy dataset.
    For instructions, see Creating a visual.
  2. In the VISUALS menu, find and click Packed Bubbles.
    The shelves of the visual changed.

    They are now Dimension, Measure, Color, Tooltips, X Trellis, Y Trellis, and Filters.

    Both Dimension and Measure are mandatory.

  3. Populate the shelves from the available fields (Dimensions, Measures) in the DATA menu.
    1. Under Dimensions, select country and drag it to the Dimension shelf.
    2. Under Measures, select population and drag it to the Measure shelf.
  4. Change the aggregate of the population field from sum(population) to avg(population):
    1. On the shelf of the visual, click the caret-right icon to the right of the field.
    2. In the FIELD PROPERTIES menu, click Aggregates > Average.
    3. Click the x icon at the top of the Column Properties menu to close it.
  5. Click REFRESH VISUAL.

    The Packed Bubbles visual appears.

  6. On the Filters shelf, add further Dimensions and Measures from the DATA menu.

    This enables you to dynamically control the data input, and discover the data at a more granular level.

    For example, from Dimensions, drag year to the Filters shelf.

  7. On the Filter shelf, click the (down arrow) icon on the year field, and select Pick values from a list.
    The Filter for year modal window appears.
  8. In the Values tab, select 2010, and click APPLY.
  9. On the Measures shelf, click the (down arrow) icon on the avg(population) field, select Order and Top K, and select Ascending.
  10. Click REFRESH VISUAL to see the updated Packed Bubbles chart.
  11. Click the pencil/edit icon next to the title of the visualization to enter a name for the visual.

    In this example, the title is changed to 'World Population - Packed Bubbles'. You can also add a brief description of the visual as a subtitle below the title of the visualization.

  12. At the top left corner of the Dashboard Designer, click SAVE.