Difference between revisions of "Working with Lists"
Gadiyedwab (talk | contribs) (Created page with "==Overview== A list shows rows of data in a tabular form. A list is a type of view. It is based on a table and shows table rows t...") |
Gadiyedwab (talk | contribs) |
||
| Line 9: | Line 9: | ||
By default, all the fields of the table are included in the list. You can control this by editing the list: | By default, all the fields of the table are included in the list. You can control this by editing the list: | ||
| − | * | + | *Selecting Fields - in the [[The Explore Analytics User Interface#View Editor|View Editor]], select fields by dragging them from the list at the top to the list of selected fields below. See [[Selecting Fields]]. |
| + | |||
| + | ==Ordering Fields== | ||
| + | |||
| + | By default, the list fields are in the same order as they are in the table. For example, if the table was created from a [[Glossary of Business Intelligence Terms#CSV File|CSV File]], the fields will be in the same order as they were in the file. You can control the order by editing the list | ||
| + | |||
| + | *Ordering Fields - in the View Editor, in the selected fields you can change the order by dragging fields name up or down to a new position. | ||
==Context Menu== | ==Context Menu== | ||
| + | |||
| + | A context menu is a pop-up menu that has options that are applicable in the given context. In the list, when you click on a cell, you get a pop-up menu with options such as: | ||
| + | |||
| + | *'''Show matching''' - adds a condition to the filter to only show rows with the value of this cell. For example, if you click on "NY" in the "State" column and select "Show Matching", then a condition would be added to only show rows for "NY". | ||
| + | *'''Exclude''' - adds a condition to the filter to exclude rows with the value of this cell. In the previous example, clicking "Exclude" on "NY" will show data for all states except "NY". | ||
| + | |||
| + | The context menu can have other options depending on the context. Explore Analytics uses lists to display views, data sources, tables, and more. When displaying views, for example, based on your permissions you may see an option to delete the view. | ||
| + | |||
==Sorting the List== | ==Sorting the List== | ||
==Changing Field Labels== | ==Changing Field Labels== | ||
Revision as of 02:35, 28 June 2012
Contents
Overview
A list shows rows of data in a tabular form. A list is a type of view. It is based on a table and shows table rows that match the filter conditions. It shows data for one or more fields from this table or from related table (by following reference fields).
Each list column corresponds to a field.
Selecting Fields
By default, all the fields of the table are included in the list. You can control this by editing the list:
- Selecting Fields - in the View Editor, select fields by dragging them from the list at the top to the list of selected fields below. See Selecting Fields.
Ordering Fields
By default, the list fields are in the same order as they are in the table. For example, if the table was created from a CSV File, the fields will be in the same order as they were in the file. You can control the order by editing the list
- Ordering Fields - in the View Editor, in the selected fields you can change the order by dragging fields name up or down to a new position.
Context Menu
A context menu is a pop-up menu that has options that are applicable in the given context. In the list, when you click on a cell, you get a pop-up menu with options such as:
- Show matching - adds a condition to the filter to only show rows with the value of this cell. For example, if you click on "NY" in the "State" column and select "Show Matching", then a condition would be added to only show rows for "NY".
- Exclude - adds a condition to the filter to exclude rows with the value of this cell. In the previous example, clicking "Exclude" on "NY" will show data for all states except "NY".
The context menu can have other options depending on the context. Explore Analytics uses lists to display views, data sources, tables, and more. When displaying views, for example, based on your permissions you may see an option to delete the view.
