MicroStrategy ONE
Create a Derived Metric by Selecting the Aggregation Function
You can create a derived metric by selecting the aggregation function used to calculate values in an existing metric. Aggregation functions are used to calculate subtotals for a metric (for example, Sum, Average, Standard Deviation, Median, etc.).
You can create a derived metric that calculates the average of the Revenue metric values. The derived metric is automatically named Avg(Revenue), although you can change it.
- Open the dossier you want to modify.
- Create a derived metric and reserve it for future use in a visualization. In the Datasets panel, right-click the metric to use to create a derived metric and choose Aggregate By.
- Select the aggregation function to use to calculate metric values.
Related Topics
Introduction to Derived Metrics
Create a Derived Metric Using the Metric Function Editor
Create a Derived Metric On a Grid Using a Shortcut
Create a Derived Metric by Combining Two Metrics with an Operator
Create a Derived Metric by Combining Multiple Metrics
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