Create Google Line Multi Series Chart from Pivot Table
In many cases your reports return multiple columns of data. If you want to perform multi series 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 Multi Series chart using the results from a pivot table.
Google documentation on Line Chart API can be found at https://google-developers.appspot.com/chart/interactive/docs/gallery/linechart
1. Choose a Report that contains a Time Series of multiple items
In this example, the calendar_date column contains the time series data
2. Add Pivot
- Navigate to Charts and Pivots tab
- Click Add Pivot button
3. Define Pivot Parameters
4. Full Pivot Editor Displays
- Input a meaningful Name
- Adjust any values on the Pivot Editor
Save
5. Associate a Chart with the Pivot Table
- Navigate to the Pivot Charts tab
- Click New Chart button
6. Full Chart Editor Displays
- Input a meaningful name for your chart
- Optionally edit X-axis title
- Optionally edit Y-axis title
Save & publish