Difference between revisions of "Using Multiple Tables in a View"

From Explore Analytics: The Wiki
Jump to navigation Jump to search
(Created page with "==Introduction== Explore Analytics makes it easy to combine data from multiple tables in a view. You start your view based on a table, and then add fields from related tables...")
 
Line 3: Line 3:
 
Explore Analytics makes it easy to combine data from multiple tables in a view. You start your view based on a table, and then add fields from related tables to your view. Explore Analytics takes care of all the rest.
 
Explore Analytics makes it easy to combine data from multiple tables in a view. You start your view based on a table, and then add fields from related tables to your view. Explore Analytics takes care of all the rest.
  
The ability to add fields from related tables relies on the definition of [[reference fields]].
+
The ability to add fields from related tables relies on the definition of [[Data_Sources_and_Tables#Reference_Fields|reference fields]].
 +
 
 +
==Selecting Fields of Related Tables==
 +
 
 +
In the view fields dialog, you use a field list to select fields for your view. If a field is a reference field, you'll see a small right-pointing triangle ( ▶ ) next to the field name. This field points to a related table and if you click on the triangle, you'll expand the field list to show all the fields from the related table.
 +
 
 +
 
  
  
 
{{Template:TOC|View Editor|Exporting View Data}}
 
{{Template:TOC|View Editor|Exporting View Data}}

Revision as of 13:05, 9 January 2014

Introduction

Explore Analytics makes it easy to combine data from multiple tables in a view. You start your view based on a table, and then add fields from related tables to your view. Explore Analytics takes care of all the rest.

The ability to add fields from related tables relies on the definition of reference fields.

Selecting Fields of Related Tables

In the view fields dialog, you use a field list to select fields for your view. If a field is a reference field, you'll see a small right-pointing triangle ( ▶ ) next to the field name. This field points to a related table and if you click on the triangle, you'll expand the field list to show all the fields from the related table.