Exago Logo
Search
Generic filters
Exact matches only

Google Maps

Note

The system administrator can restrict access to this feature, therefore it may not be available in all environments. Contact the system administrator for more information.

The Google Maps Wizard allows interactive maps with highlighted data to appear in Advanced Reports. Geographical areas can be pinpointed or highlighted dynamically depending on report data.

HNU2cA51FS.png

 A sample Google Map visualization with a primary metric coloring the countries and three additional metrics displayed in a tooltip

This article is divided into two sections:

Add a Google Map Visualization

To add a Google Map to an Advanced Report:

  1. Select a Group Header, Group Footer, Report Header or Report Footer cell.
  2. Start the Google Maps Wizard:
    • (pre-v2021.1) Click the Google Maps GoogleMaps.png icon in the toolbar.
    • (v2021.1+) Click the Insert Insert.pngDropDownArrow2.png icon on the toolbar, then click Google_Map.png Google Maps

The Google Maps Wizard has four tabs: Locations, Data, Appearance, and Size and Preview outlined below.

Locations

Use the Locations tab to correlate data on the report with locations on the map.

ry5WADw0gY.png

Locations tab of the Map Wizard dialog

  1. Add location types by either:
    • dragging-and-dropping it to the selection pane,
    • double-clicking it, or
    • clicking on it then clicking the blue arrow icon

    Note

    Certain location types may require other types to be added or may prevent other types from being added.

    BUpjqD1kj3.png

    Adding street address requires that city and state, or city, state be added as well

  2. Choose the content of the cell that correlates to each location type from the Report Cell Value column.
    eBuUBOD1hw.png

Remove a location type by clicking the Delete X icon at the end of the row.

Click Next to advance to the Data tab.

Data

In the Data tab determine what values, called metrics, will color and display on the map. The primary metric is used to color/shade the map and any number of additional metrics may be displayed in a tooltip when the mouse hovers over a region.

E8xG4mX9rt.png

Data tab of the Map Wizard dialog

There must be a minimum of one metric. Click the Add.png Add Metric button to add additional metrics. Click the Delete icon to remove a metric.

For each metric in the list:

  1. Use the Metric dropdown to select the report cell that contains its data.
  2. Select how to summarize (aggregate) the data from the Agg. Type dropdown:
    • Sum — display the additive total of all data in the data field
    • Count — display the number of rows in this data field. For example in the data set {1, 2, 3, 3, 4, 4} the count is 6.
    • Distinct Count — display the number of unique rows in this data field. For example in the data set {1, 2, 3, 3, 4, 4} the distinct count is 4.
    • Average — display the average (arithmetic mean) of this data field
    • Minimum — display the smallest or earliest value of this data field
    • Maximum — display the largest or latest value of this data field
    • None v2018.2+ — displays the raw cell value of this data field.
  3. Enter a brief description in the Labels field.
  4. Select whether it is the Primary Metric. The Primary Metric is used to color/shade each region.

    Note

    Metrics with an Agg. Type except None may be the Primary Metric.

  5. Click the Number Format FormatCells.png icon to change how the metric is displayed in the tooltip. This will open the Number Format dialog which works very similar to the Cell Format dialog in the Advanced Report Designer. The number formatting changes will only apply if the data field is numeric.

Hyperlinks v2018.2+

A hyperlink may optionally appear in the tooltip when zoomed in to the map at the drop pin level.

lwtJbmWvJ1.png

Demo of a hyperlink in a Google Map

To do this:

  1. A cell on the report must contain the Hyperlink function.
    For example, the report below will launch a Google search for the company name when the link in the tooltip is clicked by using this formula:
    =Hyperlink("https://www.google.com/?q="&{Customers.CompanyName},{Customers.CompanyName})

    keMG62b5Et.png

  2. Add the cell with the hyperlink formula as a metric with Agg. Type set to None.

    Note

    Hyperlinks used for drop pins can be referenced from any section within the report; however, for dynamic linking, hyperlink information should be referenced from the detail section or a grouped section.

    BvC7uZhPWP.png

Click Next to advance to the Appearance tab.

Appearance

In the Appearance tab, determine the appearance of the metrics on the map.

appearancetab.png

Appearance tab of the Map Wizard dialog

Primary Metric Colors

Choose a coloring style from the list on the left, either:

  • Themes — a variety of named color themes are available (e.g. Coral, Election, Forest, etc…)
    Z0zxSYbIco.png

    Selecting the Peterbrook theme

  • Linear Range — choose a beginning (minimum) color and an ending (maximum) color. The application will automatically blend from the beginning to ending color based on the primary metric’s value. Click the color selector icon to open the color selector to choose a color.
    ol3SDHUY53.png

    Entering a linear color range

Check Show Legend to add a legend in the bottom left corner of the map.

Metric Levels

Calculate Metrics Per — select for which geographic levels to summarize the metrics. Hover the mouse over the More Information DiscoveryObjectInfoNeeded.png icon to learn more about this function.

Display Drop Pins — select whether to display drop pins, which will appear on city, street address, or latitude/longitude locations. Hover the mouse over the More Information DiscoveryObjectInfoNeeded.png icon to learn more about this function.

Note

The summary function None requires a drop pin.

Conditional Drop Pin Colors — dynamically modify a drop pin color based on its value (v2018.2+). This action is similar to conditionally formatting cells in a report.

  1. Click the FormatCells.png Conditional Drop Pin Colorsbutton.
  2. Click Add.png Add to insert a new conditional statement. Select a color that the drop pin will become when the condition is met.
  3. For each conditional color, add a condition that when true will color the drop pin. Click the Formula Editor Formula.png icon to open the Formula Editor.The left side contains a list of the Conditional Drop Pin Parameters that includes:
    • The metric values (listed in order of their creation),
    • the Location Types that are defined in the Location tab

    The right side contains all of the application’s built-in formulas. You can drag a data field or a formula to the Formula box, or type it in by hand. The editor also supports using parameters in the form @ParameterName@. For more information about building formulas, review the What are formulas? and Formula Basics articles.

    The formula must return a logical true value to cause the drop pin to become conditionally colored.

    OcqJl9n4gv.png

    Conditional Drop Pin Formatting that will color the pin red if the value of the first metric is less than 50,000; amber if it is less than or equal to 75,000; red if it is greater than 10000

  4. Click Okay to close the Conditional Drop Pin Formatting dialog.

Click Next to advance to the Size and Preview tab.

Size and Preview

Set the size, initial view, and type of map to display in the Size and Preview tab. This view will also be used when the report is exported.

googlemapes_sizeandpreview_tab.png

Size and Preview tab of the Map Wizard dialog

Note

The preview uses placeholder data values. It does not reflect the actual region shading.

Set the initial view of the map by panning and zooming to a location.

  • Click-and-drag on the map to pan.
  • Click the Zoom In and Zoom Out 1M7Dp9e8RV.png icons to change the zoom level.
  • Double-Click on a region to drill down into the child regions (e.g. double-click on a state to see data by city)

Change the size of the chart in one of three ways:

  • Drag-and-drop the resizing handle at the bottom-right corner.
  • Check Fit map to cell and which will cause the map to fill its containing cell.
  • Check Set specific size and enter a custom Height and Width in pixels

Select the style of map with the Base Map dropdown. Choose from:

  • Road Map — displays the default road map view. This is the default map type.
  • Terrain — displays a physical map based on terrain information
  • Satellite — displays Google Earth satellite images.
  • Hybrid — displays a mixture of road map and satellite views

Click Finish to add the completed visualization to the report.

Interacting with Google Maps Visualizations

On the first run, it may take a few minutes for the map to populate with data and for the metrics to be aggregated. A Loading Data message will appear in the top-left corner, then disappear once loading is completed.

AMwJnwfr2F.png

A Google Map visualization as it appears in the Report Viewer

Google Maps visualizations are interactive in a number of ways:

  • Navigate through the map
    • Click the Full Screen pPDb2Q9DHm.pngicon to open the map in a full screen view.
    • Click-and-drag on the map to pan left, right, up and down.
    • Click the Zoom In and Zoom Out 1M7Dp9e8RV.png icons, or scroll the mouse wheel to change the zoom level. At high zoom levels on Satellite and Hybrid map types two additional buttons appear:
      • Click the Rotate map 90 degrees icon akKavYrTm4.png to rotate the map.
      • Click the Tilt map N7Pz8UGkTd.pngicon to change the map’s tilt.
  • Analyze the data presented
    • Hover the mouse over a colored/shaded region to see a tooltip with the metric data. The color indicates the magnitude of the map’s primary metric.
    • Double-Click on a region to drill down into the child regions (e.g. double-click on a state to see data by city). Click [Back] to move up one level.

      96N8pssBYQ.gif

  • Other functions

    Note

    These functions are provided by Google and are not associated with the reporting application.

    • Click Report a map error to report incorrect pin locations, missing roads and landmarks or wrong business, place or road information displayed on the map
    • Click the Google logo in the lower-right corner to open the map in a new browser tab or window

Note

When an Advanced Report containing a Google Map visualization is exported to an output file type that supports visualizations (i.e. PDF, RTF or Excel) the map will be reset to the default view defined in the Size and Preview tab of the wizard.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Tags:
Table of Contents