MicroStrategy ONE

Format Dialog Box for Metrics

Use the Format dialog to specify metric-level formatting. You can select different formatting options for metric column headers and values.

Specify the following formatting options:

  • Formatting the number display allows you to determine how numeric data is displayed. For example, you can format numbers to appear as dollars and cents, as percentages, or even as scientific notation.
  • Formatting the alignment allows you to set alignment options for the data on the report inside their respective cells. For example, you can right justify the data, pad the data, and select whether to wrap text.
  • Formatting the font allows you to select the font name, script, size, and color; whether the font is bold, underlined, or italicized; and whether to strikeout the text.
  • Formatting the borders allows you to select the style and color of the border line. You can select which borders (top, bottom, left, and right) are displayed, or hide all the borders.
  • Formatting the background allows you to specify background colors, including a gradient.
  • Formatting the graph color allows you to apply a background color for the metric when it is displayed as a series in a graph report. This is available for metric headers.
  • By default, the graph color that you define for a metric overrides any default color schemes for the graph report, although you can disable this metric formatting. For more detailed instructions, see the Graphing chapter of the Advanced Reporting Help.

You can reset all changes and display the metric using its default formatting by clicking Clear Format.

You have created a metric. For instructions, see How to Create a Metric.

To format a metric

  1. If the metric is not already open, click the metric to edit it .The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric that you chose to edit.
  2. Click the Format icon Format icon. The Format dialog box opens.

  3. Select the area of the metric to format by selecting one of the following from the drop-down list at the top left:

    • To format the metric column headers (the titles), select Metric Headers.
    • To format the metric values (the numbers calculated by the metric), select Metric Values.

  4. From the left, select the type of formatting to define for the metric:

    • Number
    • Alignment
    • Font
    • Borders
    • Background
    • Graph (available only for metric headers)
  5. Select the appropriate options to define the formatting for the metric.
  6. Repeat the appropriate steps above to add additional formatting as desired.
  7. When you have finished formatting the metric, click OK to apply your changes.
  8. Click Save to save the metric and its formatting.