Table of Contents

Getting Started

How does it Work

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 an Amazon RDS Data Source

Configuring a SQLite Data Source

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

Creating a Timeline Chart

Using a Timeline Chart

Predictive Analysis

Exponential Smoothing

Category Chart

XY Chart

Map Chart

Custom Map

Pareto Chart

Calendar Chart

Chart Drill Through to Details

Chart Animation

Editing Chart Colors

Color Palette

Mashup View

Mashup Calculations

Incidents and Outages

Computers without Antivirus

Scorecard View

Scorecard View from a Pivot

Scorecard View from a Timeline Chart

Scorecard View from Independent Pivot and Timeline

Editing a Scorecard

Scorecard Group

Composite View

Publishing

Publishing a Dashboard

Scheduling a View

Scheduling a Dashboard

Tracking Trend

Dashboard

View Parameters

Slicer

Administration

Adding a User

Roles

Two Factor Authentication

Exporting Table Data

Report Development Life Cycle

Company Separation

The System Data Source

Glossary of Data Analysis and Visualization Terms

Glossary of Explore Analytics Terms

Requirements and Supported Browsers