Help & DocumentationJavaScript Charting ExamplesCreate Google Geo Chart from Pivot Table

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

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

3. Define Pivot Parameters

  1. Select Row Values
  2. Choose Column to Aggregate

Save

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

  1. Navigate to the Pivot Charts tab
  2. Click New Chart button

5.1. Select Chart Type

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

Save

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

0 Comments

Add your comment

E-Mail me when someone replies to this comment