MicroStrategy ONE
Metric Editor Formula tab: Formula definition
If you select Formula in the Metric component pane, the Definition pane in the lower part of the dialog box displays the metric formula. The formula determines the data to be used and the calculations to be performed on the data. For more information, see Simple vs. compound metrics.
Use this pane to add the facts, attributes, and/or metrics to which the metric calculation is applied and the type of aggregation the metric is to have. To add an object to the formula, find it in the Object Browser and then double-click it. By default, Sum is the default function for a fact and Count is the default function for an attribute. You can edit the formula to replace the defaults, if necessary.
The Formula definition pane also contains the following:
-
The operator bar displays arithmetic operators such as + (addition) and / (division). Click an operator to insert it into the metric formula. Click f(x) to access the Insert Function Wizard to add a function.
-
Validate confirms that the metric definition is valid for use by the MicroStrategy engine. The validation status is displayed along the bottom of the pane, shown as a green checkmark when the metric expression is valid or a red X when it is not.
-
Clear deletes the entire metric definition.
If you use at least one group function (such as sum or average) in the metric formula, the metric is a simple metric and you can set the level, condition, and transformation components. For more information, see Simple vs. compound metrics.
For more information on metrics and creating them, see the following:
Base formulas
You can save a formula as a base formula, which allows you to reuse it in other metric definitions. For more information, see Creating and saving base formulas.
-
To save a formula, select Save Expression as Base Formula from the Tools menu.
-
To reuse an existing base formula, find it in the Object Browser and double-click it.