Strategy ONE

Quickly creating a derived metric in Web

You can quickly create a derived metric based on an attribute or metric, using the Insert Metric function in MicroStrategy Web. For example, Customer is an attribute, and you want to create a metric that counts the number of distinct customers.

You can use the Insert Metric function to create a derived metric that uses one of the following functions:

  • Average
  • Count
  • Maximum
  • Minimum
  • Sum

For steps to create a derived metric using any other function, see Creating a derived metric using the Input Metric Formula dialog box.

To quickly create a derived metric in Web

  1. Open a report or document in MicroStrategy Web.
  2. In the Report Objects or Dataset Objects pane, as applicable, right-click the object that you want to base the metric on. For example, if you want to create a metric that counts the number of customers, right-click Customer.
  3. Select Insert Metric, and click the function that you want to use for the metric. The metric is created, and is shown in the Report Objects or Dataset Objects pane, as applicable.
  4. Drag the metric on to the report or document, as applicable.
  5. Click Save.