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

Managing Tags

Data Sources and Tables

Field Data Types

SQL Expression Field

Drill Down

Binning

View

Defining a Filter

Cloning a View

Sharing a View

Creating a New View

View Editor

Working with Values

Using Multiple Tables in a View

Exporting View Data

Exporting and Importing View Definition

Editing a Long-Running View

List

Working with Lists

Reporting on ServiceNow Variables

Calculated Fields

List Mashup

Pivot

Calculated Values and Calculated Columns

Calculated Values

Calculated Columns

Pivot Drill Through to Details

Coloring Rules

Formatting Categories and Values

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