Segmenting Data Qualitatively on Color Shelves of Interactive Maps

Arcadia Enterprise enables you to plot qualitative ranges of data by specifying the data segmentation on the Color shelf.

The following steps demonstrate how to plot incident counts on an interactive map. We are using truck movement data.

  1. Select the appropriate dataset, and create a new dashboard; in the dashboard, open the default visual and change the visual type to Interactive Map.
  2. Enable Circles, as described in Displaying Circles: click the Settings menu, select Circles, and then select the Enable Circles option.

  3. Similarly, enable both the area and color legends of Circles by selecting the Add Circles Area Legend and Add Circles Color Legend options.
  4. [Optional] Disable all the other layers: heatmap, cluster, marker, and route.
  5. Populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.

    • 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. Click the filed on the shelf; in the Field Properties menu, select Change Type, and then select Latitude or Longitude, as appropriate. See Change Type and Geo Data type.

    • Measures Shelf

      Under Measures, select eventtype and place it on the measures shelf.

      Change the aggregation function to count(), and Alias the field as # Incidents.

    • Colors Shelf

      Under Measures, select eventtype, and place it on the Colors shelf.

      Click the field on the shelf, and in the Field Properties menu, select the [] Enter/Edit Expression option. 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

      Change the field Alias to # Lane Departures.

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

  6. [Optional] Change the color palette to ensure that the colors are distinct. In this case, because we are dividing the data into two distinct groups, we choose a two-color palette.

    Click Colors, and select an appropriate palette.

  7. Click Refresh Visual.

  8. The visual appears.

  9. Change the title of the visual, and Save it.