Create Google Geo Chart from Pivot Table

This article provides a step by step example of creating a Google Geo chart, using the results from a pivot table.

In many cases your reports return multiple columns of data. If you want to perform simple two axis reporting on this data using a JavaScript chart, create a Pivot table on the report and then associate a chart with the Pivot.

Google documentation on the GeoChart API can be found at https://developers.google.com/chart/interactive/docs/gallery/geochart

1. Select a Report

2. Add Pivot Table

Add Pivot TableZoom: Add Pivot Table
  1. Navigate to Charts and Pivots tab
  2. Click Add Pivot button

3. Define Pivot Parameters

Define Pivot ParametersZoom: Define Pivot Parameters
  1. Select Row Values
  2. Choose Column to Aggregate

Save

4. Full Pivot Editor Displays

Full Pivot Editor DisplaysZoom: Full Pivot Editor Displays
  1. Adjust any settings on the Pivot Editor
  2. Save

NOTE: In this example, the defaults are left as they are. The two columns for this Pivot are "country" and "Amount"

5. Associate a Chart with the Pivot Table

Associate a Chart with the Pivot TableZoom: Associate a Chart with the Pivot Table
  1. Navigate to the Pivot Charts tab
  2. Click New Chart button

5.1. Select Chart Type

Select Chart TypeZoom: Select Chart Type
  1. Select "Google Geo (Google Charts)" as Chart type

Save

6. Full Chart Editor Displays

Full Chart Editor DisplaysZoom: Full Chart Editor Displays
  1. Input a meaningful name for your chart
  2. Optionally edit X-axis title
  3. Optionally edit Y-axis title

Save & publish

7. Chart Displays in Report Viewer