Cloudera Docs

Segmenting data qualitatively in interactive maps

CDP Data Visualization enables you to plot qualitative ranges of data by specifying the data segmentation on the Color shelf of an Interactive Map visual.

The following steps demonstrate how to plot incident counts on an Interactive Map. Truck movement data is used in the example.

  1. Select the appropriate dataset, and create a new dashboard.
  2. In the dashboard, open the default visual and change the visual type to Interactive Map.
  3. Enable Circles, as described in Displaying circles.
    1. Click the Settings menu.
    2. Select Circles > Enable Circles.
  4. Enable both the area and color legends of Circles by selecting the Add Circles Area Legend and Add Circles Color Legend options.
  5. Optional: Disable all the other layers: heatmap, cluster, marker, and route.
  6. Populate the shelves from the available fields (Dimensions and Measures) in the DATA menu.
    1. Geo Shelf - Under Measures, select latitude and longitude, and add them to the Geo shelf.
      If your longitude and latitude measurements are not automatically recognized (appear with a (globe) icon on the Geo shelf), cast them to the appropriate Geo Type.
      1. Click the field on the shelf to open the FIELD PROPERTIES menu.
      2. Select Change Type and choose Latitude or Longitude as appropriate.
      For more information, see Change type and Geo data type.
    2. Measures Shelf - Under Measures, select eventtype and place it on the measures shelf.
      1. Change the aggregation function to count().
      2. Alias the field as # Incidents.
    3. Colors Shelf - Under Measures, select eventtype and place it on the Colors shelf.
      1. Click the field on the shelf, to open the FIELD PROPERTIES menu.
      2. Select the [] Enter/Edit Expression option.
      3. Change the field expression to split the data into two qualitative ranges, High and Low:
        case when count([eventtype]) > 20 then 'High' else 'Low (20 or less)' end

      4. Change the field Alias to # Lane Departures.

    4. Filters Shelf - Add the field eventtype to this shelf, and select the single value 'Lane Departures'.

      [Optional] Add the field drivername to the filters shelf, and select a small number of drivers to see details.

  7. Optional: Change the color palette to ensure that the colors are distinct: Click Colors, and select an appropriate palette.
    In this example, because the data is divided into two distinct groups, a two-color palette is chosen.
  8. Click REFRESH VISUAL.
    The visual is displayed.
  9. Change the title of the visual, and SAVE it.