Explore Analytics: The Wiki

From Explore Analytics: The Wiki
Jump to navigation Jump to search

The Explore Analytics User's Guide

Table of Contents

Product Overview

How does it Work

From Data to Insight

Getting Started

Explore1.pngPreparing 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

Explore2.pngExploring

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

Explore3.pngVisualization

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

Explore4.pngAdministration

Adding a User
Roles
Two Factor Authentication
Exporting Table Data
Report Development Life Cycle
Company Separation
The System Data Source

Explore5.pngServiceNow

Configuring a ServiceNow Data Source
Reporting on ServiceNow Variables
Business Service Reporting
Business Service Filter
Business Service Field
IT Service Management App
Latest Release Notes

Explore5.pngApps

Creating Analytical Applications
IT Service Management

Glossary of Data Analysis and Visualization Terms

Glossary of Explore Analytics Terms

Requirements and Supported Browsers