• Metric Functions
• Some useful functions to use in metrics include:
• Rank
• Count
• Running and Moving Sums and Averages (also called OLAP functions)
• N-Tile
• First and Last

  All of the above except count and first/last are non-group functions. Non-group functions are used in compound metrics.

• Creating Your Own Plug-In Functions
• Apply Functions: Using Database-Specific Functions in Metrics

The following sections contain a brief overview of the functions in each group listed above; for complete details about these and other functions see the Functions Reference.

Other useful functions include those used in subtotals and data mining. For descriptions of subtotal functions, see Defining Subtotal Defaults. Refer to Data Mining Services for information on data mining and predictive metrics.