Cloudera Docs

Areas

In CDP Data Visualization, Areas visuals are a good choice for representing related values over time because they emphasize the relative proportions of totals or percentage relationships. With volume stacked beneath the line, the chart clearly demonstrates both the total of the fields and their relative size.

The following steps demonstrate how to create a new Areas visual on the World Life Expectancy dataset. For an overview of shelves that specify this visual, see Shelves for areas.

  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 Areas.

    The shelves of the visual changed. The mandatory shelves are X Axis and Y Axis. The fields placed on these two shelves may be easily swapped by switching X and Y.

  3. Populate the shelves from the available fields (Dimensions, Measures) in the DATA menu.
    1. Under Dimensions, select year and drag it to the X shelf.
    2. Under Measures, select population and drag it to the Y shelf.
  4. Change the aggregate of the population field from sum(population) to avg(population):
    1. Click the field to open the FIELD PROPERTIES menu.
    2. Select Aggregates > Average.
    3. Click the x icon at the top of the FIELD PROPERTIES menu to close it.
    4. Click REFRESH VISUAL.

      The Areas visual appears.

  5. Alias the year field as Year, and the population field as Population:
    1. Click the field to open the FIELD PROPERTIES menu.
    2. Select Alias and enter the alias name of the column in the text box as it should appear in the visual.
    3. Click the x icon at the top of the FIELD PROPERTIES menu to close it.
    The shelf now shows the fields with their alias names.
  6. To see the individual countries, select the country field from the list of Dimensions and drag it to the Colors shelf.
  7. Optional: On the Tooltips shelf, add several fields from Dimensions and Measures.

    This enables you to see specific descriptive information in your visuals, such as input values, segment affiliation, and calculations.

    For example:

    1. From Measures, drag gdp_per_capita and life_expectancy to the Tooltip shelf.
    2. From Dimensions, drag country, un_subregion, and un_region to the Tooltip shelf.
    3. For all items on the Tooltip shelf, click the (down arrow) icon and select Aggregates > Remove Aggregate.
    4. For all numeric items on the Y shelf and the Tooltip shelf, click the (down arrow) icon, select Display Format, and enter ,.2f.

      These fields are typically from the Measures menu. In this example include gdp_per_capita and life_expectancy.

  8. 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 country, un_subregion, un_region, and year to the Filters shelf.

  9. On the Filters shelf, click the (down arrow) icon on the un_region field.
  10. Select Pick values from a list.
  11. In the Pick values for un_region modal window, select Africa and click Save.
  12. Click REFRESH VISUAL.

    The updated Areas visual appears.

  13. Click the (pencil) icon next to the title of the visual to edit it, and change the title to World Population - Area.
  14. At the top left corner of the Dashboard Designer, click SAVE.