For metrics, you can configure a custom display name. For metrics that are not predefined, you also can select the aggregation method.
The aggregation method is the function used to consolidate the metric values into a single value for each group dimension value, or for each combination of group and series dimension values.
For example, a view contains a list of sales transactions, including the sales amount and the country. If the chart is grouped by country, then to get a single sales amount value for each country, you might add together all of the values for each country, calculate the average of the values for each country, or select the largest value for each country.
The available aggregation methods are:
| sum | Calculates the total value for the metric.
You can only use this aggregation method for numeric values. |
| average | Calculates the average value for the
metric.
You can only use this aggregation method for numeric values. |
| median | Calculates the median value for the metric.
You can only use this aggregation method for numeric values. |
| min | Selects the minimum value for the metric.
You can only use this aggregation method for numeric values. |
| max | Selects the maximum value for the metric.
You can only use this aggregation method for numeric values. |
| count | Calculates the number of records with a value for the metric. |
| distinct | Calculates the number of unique values for the metric. |
| variance | Calculates the variance (square of the
standard deviation) for the metric values.
You can only use this aggregation method for numeric values. |
| std dev | Calculates the standard deviation for the
metric values.
You can only use this aggregation method for numeric values. |
To show how each of the aggregation methods work, we'll use the following data:
| Country | Amount of Sale | Shipping Company |
|---|---|---|
| US | 125.00 | UPS |
| US | 50.00 | UPS |
| US | 150.00 | FedEx |
Country is the group dimension. The Amount of Sale and Shipping Company are the metrics.
Based on these values, the aggregation for Amount of Sale and Shipping Company for the US would be:
| Aggregation Method | Amount of Sale (US) | Shipping Company (US) |
|---|---|---|
| sum | 225.00 | Cannot be aggregated |
| avg | 108.33 | Cannot be aggregated |
| median | 125.00 | Cannot be aggregated |
| min | 50.00 | Cannot be aggregated |
| max | 150.00 | Cannot be aggregated |
| count | 3 | 3 |
| count distinct | 3 | 2 |
| variance | 2708.33 | Cannot be aggregated |
| standard deviation | 52.04 | Cannot be aggregated |
You can select the aggregation method directly from the Series Metrics list. The edit dialog allows you to change both the aggregation method and the display name.
To configure a metric:
-
From the
Chart Configuration tab, to select a different
aggregation method for a non-predefined metric:
- Click the drop-down arrow next to the metric name.
-
From the drop-down list, select the aggregation method.
-
To configure both the display name and the aggregation method:
- Click the edit icon for the metric.
-
On the metric configuration dialog, to use the default display
name, click the
Use default name radio button.
For metrics that are not predefined, the default display name is the attribute name followed in parentheses by the aggregation method. For example, Sales (sum).
-
To use a different display name, click the
Custom name radio button. In the field,
type the display name.
- For a non-predefined metric, from the Aggregation method drop-down list, select the type of aggregation to perform.
- Click Apply.
