Google Maps

Google Maps are interactive maps that plot data per geographic area. Google Maps use data highlighting, whereby data color-codes areas in varying levels of intensity. Highlighting can affect multiple levels of granularity, to allow for drilling down into regions.

     

A Google Map viewed at the state level and the county level

To add a Google Map to a report, select the report cell where you want the map to appear. Then click the  Google Map Wizard icon. Proceed through the Locations, Data, Appearance, and Size and Preview pages, then click Finish when you are done.

To edit a Google Map, double-click it, or select it and click the  Google Map Wizard icon to reopen the wizard.

Locations

Select the locations to use for data highlighting. Google Maps support up to six levels of granularity of locations. Some location types require data for enclosing types, in order to disambiguate location names. For each location type, select the report cell that contains the location names.

Use the following chart to determine the required data for different location types. Start at a slice and follow the chart inward to find its required locations.

Location requirements

Alternately, you can use latitude and longitude to place drop pins at coordinates on the map.

 Caution
County and Zip Code locations are only available for data based in the United States.

Data

Select the data to highlight each location, and optionally, additional metrics to see in a tooltip when hovering over a location. The Primary Metric sets the data highlighting.

Hover tooltip with three metrics

To add a metric, click Add Metric.

To delete a metric, click the Delete  icon next to the metric to delete. There must be at least one metric.

For each metric:

  1. Select the report cell that contains the data for that metric from the Metric list.

  2. Choose how to aggregate the data from the Agg. Type list.

    Select None to display a cell value within the drop pin tooltip.

  3. Enter a label for the metric in the Labels field. The label will show in the hover tooltip.

  4. Optional: Click the Number Format  icon to change how the data values will show in the hover tooltip. See Cell Format for details.

Appearance

In the Primary Metric Colors pane, determine the color range to use for highlighting. Do one of the following:

Selecting Show Legend adds a legend in the bottom left corner of the map that displays a color scale for reference and the minimum and maximum values of the currently visible regions.

 Tip
Areas with no data are not shaded.

In the Metric Levels pane, you can select which levels of location are highlighted. Clear the check box for a level to prevent highlighting and drilling down into that level of data.

You can also select whether to Display Drop Pins instead of highlighting for the lowest location level available in your data.

Conditional Drop Pin Colors

Use this menu to dynamically modify a drop pin color based on its value. This action is similar to conditionally formatting cells in a report. 

To conditionally set the drop pin colors for a Google Map:

  1. Click  Add to insert a new conditional statement.

  2. Select a color that the drop pin will become when a condition is met.

  3. Click the formula  icon to open the formula editor. Write a formula that returns True() or False() to indicate whether the pin should use the specified color. Conditional formulas take precedence in order that they appear in the Conditional Drop Pin Formatting menu.

    The following special parameters are available within the Conditional Drop Pin Formula Editor:

  4. Click Okay when done.

Size and Preview

Determine the size, initial view, and style of the map.

Set the initial view by panning and zooming the map. Drag in a direction on the map to pan. Click the zoom buttons to zoom in  and out .

To set the size, either:

Select the style of map from the Base Map list.

     

Road map versus Terrain map