Help & DocumentationJavaScript Charting ExamplesCreate Google Line Chart from Pivot Table

Create Google Line Chart from Pivot Table

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

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

Google documentation on the Line Chart API can be found at https://google-developers.appspot.com/chart/interactive/docs/gallery/linechart

1. Select a Report

2. Add Pivot

Add PivotZoom: Add Pivot
  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. Input a meaningful Name
  2. Adjust any values on the Pivot Editor

Save

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 Line 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

0 Comments

Add your comment

E-Mail me when someone replies to this comment