Cloudera Docs

Packed bubbles

CDP Data Visualization enables you to create Packed Bubbles visuals.

Packed bubble charts compare the relative values in close physical proximity. We use two main series of data: the field on the Dimensions shelf names the bubble, and the field on the Measures shelf determines the relative area of the bubble.

Contrast this with 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 Cloudera's scatter charts.

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

  1. Start a new visual based on dataset World Life Expectancy [data source samples.world_life_expectancy]; see Creating a visual.
  2. In the visuals menu, find and click Packed Bubbles.
    selecting packed bubbles chart type
    selecting packed bubbles chart type
  3. Note that the shelves of the visual changed.

    They are now X, Y, Dimensions, Measures, Tooltips, and Filters.

    Both Dimensions and Measures are mandatory.

    shelves of packed bubbles visual type
  4. Populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.
    1. Under Dimensions, select country and drag it over Dimensions shelf on the main part of the screen. Drop to add it to the shelf.
    2. Under Measures, select population and drag it over Y shelf on the main part of the screen. Drop to add it to the shelf.
  5. 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 Column Properties menu, click the caret-right icon next to Aggregates.
    3. From the list of aggregate functions, select Average.
      changing the aggregation to average
    4. Click x icon at the top of the Column Properties menu to close it.
    5. Click x icon at the top of the Column Properties menu to close it.
  6. Click Refresh Visual.

    The packed bubble visual graph appears.

  7. On the Filters shelf, add several 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 onto the Filters shelf.

  8. On the Filter shelf, click the (down arrow) icon on the year field, and select Pick values from a list.
  9. In the Pick values for year modal window, select 2010, and click Save.
  10. On the Measures shelf, click the (down arrow) icon on the avg(population) field, select Order, and then select Ascending.
  11. Click Refresh Visual to see the updated packed bubbles chart.
  12. Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.
  13. Change the title to World Population - Packed Bubbles.
  14. At the top left corner of the Visual Designer, click Save.