Google Visualization API Essentials电子书

Google Visualization API Essentials

Table of Contents

Google Visualization API Essentials

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Tools and Setup

Knowledge prerequisites

Skill summary

System requirements

Interacting with Google Visualization Tools

Charts for Google Spreadsheets

Getting started – creating a new spreadsheet

Fusion Tables

Getting started – creating a new Fusion Table

Scripting code

Code Playground

Debugging tools

Console

Gadget Editor

Summary

2. Anatomy of a Visualization

Common structure

Apps Script

Forms

Framework

Fusion Tables

Scripting code

HTML Framework

Technique options

Comparison: chart.draw() versus ChartWrapper versus Draw.Chart()

Categories of visualizations

Static

Interactive

Dashboards

Filter by string

Filter by number range

Filter by chart range

Programmatic filtering

Filter by category

Filter by dependencies

Events

Selection and sort

Ready for interaction

Error handling

Time-based charts

Annotated timeline charts

Motion charts

Summary

3. Spreadsheets, Charts, and Fusion Tables

Spreadsheets

Creating a chart

The Chart Editor

Chart types

Reopening the Chart Editor

Chart styles

Using Apps Script

Framework

Scripting console

Testing functions

Debugging scripts

Event triggers

Publishing as an App

Fusion Tables

Importing or creating data

Data management

Editing rows

Modifying columns

Adding a formula

Views

New look in Fusion Tables

Merging tables

Creating a visualization

Non-map visualizations

A simple line graph

Experimental charts

Mapping features

Geocoding

Manual method

Address method

Third-party tools method

Recognizing errors

Cell formatting

Markers, lines, and area

Info windows

Summary

4. Basic Charts

Programming concepts

Variables

Number

Boolean

String

Array

Equation

API call and attributes

Conditional logic

Functions

Classes (and objects)

Libraries

Commenting

Spacing/format

Visualization API common Framework

Load API modules

Apps Script Wrapper

A basic visualization

Code Playground

Apps Script

Summary

5. Formatting Charts

Static

Spreadsheets

Fusion Tables

Chart Editor

Filters

API

Colors and fonts: Inline

Colors and fonts: Cascading Style Sheets

Views

Using DataView

Axes options

DataTable formatters

Arrow

Bar

Color

Date

Number

Pattern

Paging

Dynamic or interactive

Animated transitions

Dashboards and controls

Chart Editor for users

Summary

6. Data Manipulation and Sources

Preparing data

Google Refine – importing data

Google Refine – Facets

Google Refine – clean and supplement

Google Refine – export options

Architecture and data modification

Protocol

Visualization API data capabilities

Group and join

Spreadsheets

Forms

API

Fusion Tables – API

Data sources for Charts

Spreadsheets

Preparation

Permissions

Get the URL path

Query

Apps Script method

Fusion Tables

Preparation

Permissions

Get the URL path

Query

API Explorer

Chart Tools Query Language

Build your own data source

Summary

7. Dashboards, Controls, and Events

Architecture

HTML framework

API framework

ControlWrapper

ChartWrapper

Load

Data source

Draw

Events

Error

Ready

Select

Dashboards

Controls

StringFilter

Predictability of a control

NumberRangeFilter

CategoryFilter

ChartRangeFilter

Controls with dependencies

Programmatic control

Global variables

Transition animation

Programmatic switch

User interface toggle

Create button

Button behavior

Chart editor for users

Summary

8. Advanced Charts

Time-based charts

Motion chart

Spreadsheets

Code

Annotated timeline

Spreadsheets

Event flags and descriptions

Code

Maps

geochart versus geomap

The region option

The marker option

geochart

The ISO 3166 standard

Spreadsheets

Code

geomap

Code

Map API

Your own visualization

Summary

9. Publishing Options

Sharing

Private sharing

Public sharing

Publishing

Spreadsheets

Fusion Tables

Apps Script

Publishing basics

Embedded in a Spreadsheet

App Engine

App Engine Launcher and SDK

Eclipse plugin

Integrated Development Environments in the Cloud (IDEs)

More APIs

A word on security

Summary

Index