Glossary of Explore Analytics Terms

Breadcrumb

The breadcrumbs show the views that lead to current view and allow you to return to any of these views by clicking on the breadcrumb. To refresh the current view you can click on the right-most breadcrumb.

Chart

A chart is a visualization of the data defined by a view.

Clone

A clone is a copy operation in which a view is copied and saved under a new name. This is a handy way of creating a view based on an existing view.

Favorite

A favorite is a view that is listed in the user's Favorite menu for quick access. See Managing Favorites.

Filter

A filter defines conditions for selecting data to include in the view. You can think of a filter as declaring "select all the rows from the table that meet the following conditions". For example, the filter "hire_date during this year" says that the view will only include rows in which the hire_date is in the current calendar year.

For more information, see Defining a Filter.

Label

When listing objects such as tables, fields, and views, Explore Analytics displays the object's "label". The label may be the same as the name of the object, for example, the view's label defaults to the view name. It may be based on the name, for example, for a field named "hire_date", the label may be automatically set to "Hire Date", simply by replacing "_" with a space and capitalizing the first letter of each word. In most cases, you can change the label to suite your preference or language.

Reference

A reference is field with values that uniquely identify rows in another table. For example, an employee table might have a department field with department IDs corresponding to departments in a department table. Such a field allows us to join the employee table with the department table and show fields from both tables. In this example, to get the name of the department for each employee, we can "follow" the reference and select the employee's department name by selecting the name field from the department table.

Sidebar

The Sidebar is the area of the Explore Analytics main page that holds the menu and can also display the View Editor.

View

A view is a presentation of data in the form of a list, a pivot, or a chart. A view is based on a table and can include data from additional tables by following references. The view can include a filter to apply conditions for selecting the rows that are to be included in the view.

A view can be switches between list, pivot, and chart at any time and although it keeps its settings for all three presentations, it can only be of one of these types at any given point in time.

Unless explicitly shared or published, a view is only visible to the user who created it.

Viewing Area

The viewing area is the main part of the Explore Analytics user interface. This is where a view is displayed. It resides below the title bar and right of the sidebar.