Cloudera Docs

DMA map, choropleth

In CDP Data Visualization Map visual, you can visualize measurements on a map of DMA regions.

A DMA map shows various measurements plotted relative to Nielsen Designated Market Area Regions.

We are working with the dataset DMA TV Home Viewing, built on the dma-tv-home-viewing.csv. datafile.

  1. Start a new visual based on dataset DMA TV Home Viewing.

    See Adding data, Creating a dataset, and Crating a visual.

  2. In the visuals menu, find and click Map (row 5, column 1).
    selecting map chart type
    selecting map chart type
  3. Note that the shelves of the visual changed. They are now Geo, Color, Size, Drill, Tooltips, X Trellis, Y Trellis, and Filters.

    The only mandatory shelf for map visuals is Geo.

    shelves of map visual type
  4. Populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.
    • Under Dimensions, select dma and add it to the Geo shelf.
    • Under Measures, select homes and add it to the Color shelf.
  5. Alias the field dma as DMA, and sum(homes) as Number of Homes. See Alias.
  6. Add the dimension dma_name to the Tooltips shelf, and then alias it as DMA Name.
  7. [Optional] Enable panning and zooming option, as described in Customizing zoom.
  8. [Optional] Change the color palette, as described in Change color palette visuals.
  9. Click Refresh Visual.

    The map visual appears. You can move the visual (pan), zoom in and out, and see the details in the Tooltips text.

  10. Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.
  11. Change the title to US DMA TV Viewing Map.
  12. At the top left corner of the Visual Designer, click Save.