Detail tables enable you to view additional information about a subset of data, which is defined by the selections that you make in other visualizations.
The additional information that you see is a sampling of all of the available data.
The following table describes the elements of a detail table.
Any countable dimension for which you want to view detailed attribute and metric information. The level is preceded by the number of elements displayed out of the number of elements available, for example 6/444 indicates that 6 elements are being displayed out of a possible 444. In the example above, the level Visitors indicates that all of the detail provided is based on visitor. The level Page Views indicates that all of the detail provided is based on page view. Viewing multiple levels at the same time is useful when you want to analyze data that has different countable parents.
Any dimension that is one-to-many or one-to-one with the level, such as City to Visitors. Each row displays the element related to each element of the level you selected. In the example above, the Domain and City attributes list the domain and city for each of the sample visitors.
Metric detail about the level you have selected. In the example above, with the level set to Visitors, the metric Page Views displays the number of page views for an individual visitor, while the Page Views level provides the detail about each of those page views.
Let’s say you are working with website data and want to find out what pages visitors in particular cities and from particular domains visited during a particular time frame.
First you need to create a visualization that displays the time frame in which you are interested, then you need to select that time frame. Now you can add a detail table to view the desired details for a sample number of visitors in the dataset.
To view the details described above, you must complete the following steps:
- Right-click within the details table and click Add Level > Visitor .
- Right-click within the details table and click Add Level > Page View .
- Right-click the Visitors level heading and click Add Attribute > Geography > Domain .
- Right-click within the Visitors level heading and click Add Attribute > Geography > City .
- Right-click within the Visitors level heading and click Add Metric > Page Views .
- Right-click within the Page Views level heading and click Add Attribute > Page > Page .
The following sample workspace shows you the related details for a random sampling of six visitors to the site during the time frame you specified.
Add a level
- Right-click within the detail table and click Add Level > < dimension name > .
Remove a level
- Right-click the existing level heading and click Remove Level > < dimension name > .
Add attributes and metrics
- Right-click an attribute or metric heading and click Add Attribute > < attribute name > or Add Metric > < metric name > .
Remove attributes and metrics
- Right-click the column that you want to remove and click Remove Attribute > < attribute name > or Remove Metric > < metric name > .
Export to Microsoft Excel
For information about exporting windows, see Exporting Window Data .