Selecting the attributes to use on a component

For many Studio components, you need to select the attributes to use for the component.

If you only need to select a single value, then the component edit view includes a button or link to display the list of available attributes.

If you can set up lists of values, then the list of available attributes is displayed directly on the edit view, and you can drag and drop attributes from the list.

In some cases, such as Results List or a record list Results Table, you are simply selecting attributes to display, without any aggregation. The available attributes list then only displays attributes.

For other components, such as Chart and Pivot Table, you are selecting aggregated metric values, and the dimensions to use for the aggregation. For components that display aggregated data, the attributes list:

• Uses icons to indicate whether each attribute can be used as a metric or a dimension
  
  
  

  Note that multi-value date/time attributes cannot be used as dimensions, and are not included in the list.

• Includes the predefined metrics from the selected view
• Includes the following system metrics:

  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 component is aggregated using the dimensions Country and Product Line. The current item 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.
  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 current dimension values. When you add this metric, you are prompted to select the attribute to use. You can only select an attribute that has the count aggregation enabled. For example, a component is aggregated using Country and Product Line. The current item 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.
  Number of unique values	Displays the number of unique values (other than NULL) for a selected attribute for the current dimension values. When you add this metric, you are prompted to select the attribute to use. You can only select an attribute that has the count distinct aggregation method enabled. For example, a component is aggregated using Country and Product Line. The current item 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.

To select values for a component:

1. To select a single value:
   1. Click the link or button.
   2. On the attribute list dialog, click the attribute to select.

      You can use the filter field to search for a particular attribute.

   3. Click Apply.

   When you select a metric attribute, Studio assigns the default aggregation method for that attribute.

   When you select the Number of records with values or Number of unique values metric, Studio prompts you to select the attribute to use.

2. To populate lists of values for a component:
   1. To add an attribute to a list, drag it from the available attributes list to the appropriate destination location on the component edit view.

      You can use the filter field to search for a particular attribute.

      When you begin dragging the attribute, Studio highlights the locations where you are allowed to drop it.

      For example, if you are dragging a metric, you cannot drop it into a dimensions list.

   2. Drop the attribute into the destination location.

      When you drop an attribute into a metrics list, Studio assigns the default aggregation method for that attribute.

      When you drop a Number of records with values or Number of unique values attribute, Studio prompts you to select the attribute to use.

3. To configure a selected attribute, click its edit icon.
4. To remove a selected attribute, click its delete icon.