MicroStrategy ONE

Formatting derived metrics

The same formatting options for regular metrics on a report are available for derived metrics.

You can format the metric headers and values for a derived metric included on the report grid. To format a derived metric, right-click the derived metric on the grid, point to Formatting, and select the derived metrics headers or values. The Format Cells dialog box opens to modify the derived metric formatting. For an example of creating and formatting a derived metric, see Example: Average profit per customer with transactions. For instructions to format a metric, see About formatting metrics on a report.

You can also use thresholds with derived metrics in the same ways you can use thresholds with standard metrics created with the Metric Editor. Thresholds are used to create conditional formatting for metric values. To open the Threshold dialog box for a derived metric, right-click the derived metric on the report grid and select Thresholds. For further instructions, see Applying thresholds.

Related Topics