Designing reports, documents, and dashboards » Creating and modifying dashboards using Flash » Adding derived metrics to a dashboard created using Flash

Adding derived metrics to a dashboard created using Flash

You can create new metrics (called derived metrics) based on attributes and metrics that have already been added to a dashboard. For example, you can create a new metric by subtracting the values of one metric from the values of another metric, such as Revenue Forecast - Revenue. You can rank a metric's value from least to greatest, or display metric values as percentages of an accumulated total.

A derived metric performs a calculation on-the-fly with the data available on a dashboard, without re-executing the dashboard against the data source. Derived metrics are saved and displayed only in the specific dashboard in which they are created.

For background information on derived metrics, see About derived metrics. For steps to create, modify, or delete derived metrics in a dashboard, see the appropriate topic below:

You can quickly and easily add simple derived metrics, such as running sum or percent-to-total metrics, to a dashboard. For steps, see Adding derived metrics to a dashboard on-the-fly.
You can quickly create a new metric based on a MicroStrategy function, by selecting the function and providing the required arguments for the function from data in the dashboard. For steps, see Creating derived metrics based on functions in a dashboard.
You can create complex derived metrics from scratch, using attributes, metrics, functions, and arithmetic operators. For steps, see Creating a new derived metric in a dashboard from scratch.
You can modify or delete derived metrics in a dashboard. For steps, see Editing or deleting derived metrics in a dashboard.

Related topics

Creating a dashboard
Editing or deleting derived metrics in a dashboard