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
- Navigate to Charts and Pivots tab
- Click Add Pivot button
3. Define Pivot Parameters
- Select Row Values
- Choose Column to Aggregate
Save
4. Full Pivot Editor Displays
- Adjust any settings on the Pivot Editor
- 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
- Navigate to the Pivot Charts tab
- Click New Chart button
5.1. Select Chart Type
- Select "Google Geo (Google Charts)" as Chart type
Save
6. Full Chart Editor Displays
- Input a meaningful name for your chart
- Optionally edit X-axis title
- Optionally edit Y-axis title
Save & publish