Difference between revisions of "Selecting Fields"

From Explore Analytics: The Wiki
Jump to navigation Jump to search
Line 19: Line 19:
 
[[File:field_select.png]]
 
[[File:field_select.png]]
  
{{Template:Visualization|Map Chart|Glossary of Data Analysis and Visualization Terms}}
+
{{Template:Exploring|The Explore Analytics User Interface|Managing Favorites}}

Revision as of 13:28, 4 November 2013

Overview

Explore Analytics makes it easy to create views using data from more than one table by using reference fields. Such fields relate their table to other tables. For example, the "department" field in the "employee" table relates the "employee" table to the "department" table. It allows us to show fields from both tables when listing employee records.

When selecting fields, Explore Analytics provides a hierarchical list of fields. In the above example, the department fields will be nested under the department field of the employee table.

When you first open a fields list, you see the fields of the table listed alphabetically. If the table has any reference fields, you'll be able to expand the list to see the fields of the related table under the reference field.

Selecting Fields using the Fields Drop-Down

The Fields Drop-Down is used in Filters and in other cases where you need to select a single field.

Field drop down.png

Selecting Fields using the Fields List

The Fields List is used or selecting multiple field in the View Editor. You make selection by dragging fields into another list. Fields that are already selected are highlighted in bold.

Field select.png

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