Metric Editor Subtotals/Aggregation tab: Functions

The following is a description of the standard functions available on the Subtotals/Aggregation tab. Any user-defined subtotals that have been created in the project also appear in the lists on this tab.

Function	Expression	Description
Average	Avg[Average]	Sum of input values divided by count of input values
Count	Count[Count]	Number of input values
Geometric Mean	GeoMean[Geometric Mean]	Square root of subtotals product
Maximum	Max[Maximum]	Highest input value
Median	Median[Median]	Middle value when input values are sorted
Minimum	Min[Minimum]	Lowest input value
Mode	Mode[Mode]	Most frequent input value
Product	Product[Product]	Multiplication of all input values together
Standard Deviation	Stdev[Standard Deviation]	Spread of input values
Sum	Sum[Total]	Sum of input values
Variance	Var[Variance]	Square of the spread of input values

Related Topics

• About metric subtotals

• Specifying dynamic aggregation functions

• Applying user-defined subtotals to metrics

• Defining metric subtotal functions

• Making subtotals available to a metric

• Disabling metric subtotals

• Subtotals/Aggregation tab: Layout

For examples of functions and usage notes, see the Functions Reference.