MicroStrategy ONE

Accessing functions for a derived metric

Use the Input Metric Formula dialog box to create derived metrics, which are created from objects already present in the report.

  1. From the Insert menu in the Report Editor, select New Metric. Or, right-click above a metric heading in the Report Grid, point to Insert, and then select New Metric in the shortcut menu. The Input Metric Formula dialog box is displayed.

  2. Build a metric using the available report objects. Access the functions in one of the following ways:

    • Expand the Functions and Operators folder using the drop-down list or folder list. Then expand the Functions, Operators, or Plug-In Packages folder to access the various categories of functions and operators.

    • Click f(x) (Insert Function) in the Definition pane. The Insert Function wizard opens.

    • Type the function name and all required metric syntax directly in the Enter your formula here box.