Difference between revisions of "Glossary of Explore Analytics Terms"
Gadiyedwab (talk | contribs) |
Gadiyedwab (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | ==Chart== | |
A ''chart'' is a [[Glossary of Data Analysis and Visualization Terms#Data Visualization|visualization]] of the data defined by a [[#view|view]]. | A ''chart'' is a [[Glossary of Data Analysis and Visualization Terms#Data Visualization|visualization]] of the data defined by a [[#view|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. | 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]]. | 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. | 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. | ||
| Line 17: | Line 17: | ||
For more information, see [[Defining a Filter]]. | For more information, see [[Defining a Filter]]. | ||
| − | + | ==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. | 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. | 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 [[Glossary of Data Analysis and Visualization Terms#List|list]], a [[Glossary of Data Analysis and Visualization Terms#Pivot|pivot]], or a [[#Chart|chart]]. A view is based on a [[Glossary of Data Analysis and Visualization Terms#Table|table]] and can include data from additional tables by following [[#Reference|references]]. The view can include a [[#Filter|filter]] to apply conditions for selecting the rows that are to be included in the view. | A ''view'' is a presentation of data in the form of a [[Glossary of Data Analysis and Visualization Terms#List|list]], a [[Glossary of Data Analysis and Visualization Terms#Pivot|pivot]], or a [[#Chart|chart]]. A view is based on a [[Glossary of Data Analysis and Visualization Terms#Table|table]] and can include data from additional tables by following [[#Reference|references]]. The view can include a [[#Filter|filter]] to apply conditions for selecting the rows that are to be included in the view. | ||
Revision as of 23:50, 27 June 2012
Contents
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.
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.
