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.
- Open a dashboard that contains a grid visualization.
- 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.
- Select the function you want to use to define the derived metric and click OK.
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 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