MicroStrategy ONE

Create a Derived Metric On a Grid Using a Shortcut

You can create a simple derived metric and add it immediately to a grid visualization, using a menu shortcut.

Shortcut metrics are only available in grid visualizations.

  1. Open a dashboard that contains a grid visualization.
  2. You can create a derived attribute and immediately add it to a grid visualization, as well as the Datasets panel. Select the grid visualization you want to add the derived metric to. In the Editor panel, right-click the metric to use to create the derived metric and choose Shortcut Metric.
  3. Select the function you want to use to define the derived metric and click OK.
  4. If you are creating a Running Total, select the function to use for the calculation, such as Sum to calculate a running sum or Average for a running average. Then, select how to break the running total. Breaking the running total restarts the total. You can select an attribute and the total is restarted for each element in the attribute.

Related Topics

Introduction to Metrics

Introduction to Derived Metrics

Create a Derived Metric Using the Metric Function Editor

Create a Derived Metric by Combining Two Metrics with an Operator

Create a Derived Metric by Combining Multiple Metrics

Create a Derived Metric by Selecting the Aggregation Function

Create a Derived Metric from an Attribute

Create a Derived Metric from Scratch Using the Metric Formula Editor

Add Conditional Calculations to a Derived Metric Using the If and Case Functions

Change the Aggregation and Subtotal Behavior for a Derived Metric

Provide Statistical Analysis from R Analytics

Edit Derived Metrics from the Dashboard

Rename Derived Metrics from the Dashboard

Delete Derived Metrics from the Dashboard