When you use explicit auxiliary fields, you add the complex aggregation type field and the auxiliary fields it requires to do the value calculation to the metric.
Procedure
If you have not yet added the metric, add it using the wizard as explained in Adding a Metric Using the Wizard. If you are configuring an existing metric, open it in the Metric editor.
Add the complex aggregation field and all the auxiliary fields required to calculate the complex aggregation field value. Add auxiliary fields just as you would add any other metric field. Ensure that you use the correct aggregation types for the auxiliary fields, as explained in Complex Aggregation Types.
In the row for the complex aggregation type field, double-click the Auxiliary Fields cell and click the browse button. You see the Auxiliary Fields Selector editor.
Designate the auxiliary fields as follows:
For Average aggregation type: select the Sum and Count fields you predefined.
For StandardDeviation and Variance aggregation types: select the Sum, Count, and SumOfSquares fields you predefined.
No validity checking is done. Ensure you select the appropriate fields of the correct aggregation types.
Click OK. The auxiliary field names appear in the Auxiliary Fields cell.
Note: If you change a field from an aggregation field to a group by field, all explicit auxiliary field configuration is lost.
