Table of Contents

Getting Started

From Data to Insight

Preparing to Explore

Configuring a Data Source

Configuring an Oracle Data Source

Configuring an Oracle Cloud Data Source

Configuring a MySQL Data Source

Configuring a PostgreSQL Data Source

Configuring a DB2 Data Source

Configuring a SQL Server Data Source

Configuring a Microsoft Access Data Source

Configuring an Informix Data Source

Configuring a ServiceNow Data Source

Configuring a Salesforce.com Data Source

Configuring an Amazon RDS Data Source

Configuring a SQLite Data Source

Configuring a SugarCRM Data Source using a CDATA JDBC Driver

Refreshing Data Source Configuration

Explore Analytics Agent

Installing the Explore Analytics Agent

Installing the Explore Analytics Agent on Linux

Uploading Data

Importing a Google Spreadsheet

Exploring

The Explore Analytics User Interface

Selecting Fields

Managing Favorites

Data Sources and Tables

Field Data Types

Drill Down

View

Defining a Filter

Cloning a View

Sharing a View

Creating a New View

View Editor

Using Multiple Tables in a View

Exporting View Data

Exporting and Importing View Definition

List

Working with Lists

Reporting on ServiceNow Variables

Pivot

Calculated Values and Calculated Columns

Calculated Values

Calculated Columns

Pivot Drill Through to Details

Visualization

Timeline Chart

Category Chart

XY Chart

Map Chart

Chart Drill Through to Details

Editing Chart Colors

Mashup View

Incidents and Outages

Computers without Antivirus

Publishing

Scheduling a View

Tracking Trend

Administration

Adding a User

Roles

Exporting Table Data

Report Development Life Cycle

Glossary of Data Analysis and Visualization Terms

Glossary of Explore Analytics Terms

Requirements and Supported Browsers