Exploring

Overview

The main tool for exploring data in Explore Analytics is the View. The view provides all the capabilties to filter, sort, aggregate, apply calculations, visualize and a lot more.

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