On the edit view for an aggregated Results Table, the attributes list at the left of the Column Selection tab contains all of the available metrics and dimensions for the selected view.
The list uses icons to indicate whether the item is a dimension or a metric.
The list also contains system metrics for displaying counts of records and values.
These metrics are:
| Metric Name | Description |
|---|---|
| Number of records | Displays the number of records in the
underlying data set that have the combination of dimension values for the
current row.
For example, a table is aggregated using the dimensions Country and Product Line. The current row has United States for the country and Apparel for the product line. The number of matching records is the number of records that have the value United States for Country and Apparel for Product Line. In the table, the default column heading is Record Count. |
| Number of records with values | Displays the number of records that have a
value (any value other than NULL) for a selected attribute for the combination
of dimension values for the current row.
When you add this metric, you are prompted to select the attribute to use. For example, a table is aggregated using Country and Product Line. The current row has United States for the country and Apparel for the Product line. Of the 15 records with United States as the Country and Apparel as the product line, 4 records have Color set to Blue, 3 have Color set to Green, and 8 have no value for Color. The number of records with values for the Color attribute is then 7. In the table, the default column heading is attributeName (Record Count). |
| Number of unique values | Displays the number of unique values (other
than NULL) for a selected attribute for the combination of dimension values for
the current row.
When you add this metric, you are prompted to select the attribute to use. For example, a table is aggregated using Country and Product Line. The current row has United States for the country and Apparel for the product line. Of the 15 records with United States as the Country and Apparel for the product line, 4 records have Color set to Blue, 3 have Color set to Green, and 8 have no value for Color. The number of unique values for Color is then 2. In the table, the default column heading is attributeName (Value Count). |
