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.
-
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.
-
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.
-