Format dialog box (for metrics)

When you create or edit a metric, you can specify metric format properties such as the display of numeric values, font styles and sizes, and cell display colors. This formatting is used for the particular metric, regardless of the report on which it is placed. This is called metric level formatting, as opposed to formatting metrics at the individual report level. Formatting a metric at the report level overrides formatting at the metric level, except for graph colors, as described below.

You can create different formats for metric column headers (that is, the titles) and metric values (that is, the numbers calculated by the metric and displayed in the report).

You can specify the following formatting options:

Formatting the number display allows you to determine how the 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 apply border options, such as the style and color of the border line. You can also set which borders (top, bottom, left, and right) appear on the report.
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.

Note: 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.

To format a metric:

Prerequisites

This procedure assumes that you have created a metric. For instructions, see Creating a metric.

If the metric is not already open, click the metric to edit it. Either the Function Editor or Formula Editor opens, depending on the type of metric.
Click Format. The Format dialog box opens.
Do one of the following:
- To format the metric column headers (the titles), select Metric Headers from the drop-down list at the top left.
- To format the metric values (the numbers calculated by the metric), select Metric Values from the drop-down list at the top left.
From the list of categories on the left, select one of the following:
- Number
- Alignment
- Font
- Borders
- Background
- Graph (available only for metric values)
To reset all the formatting for this metric to the default values, click Clear Format. This applies to both metric headers and metric values.
When you have finished formatting the metric, click OK to save your changes and return to the Function Editor or Formula Editor, depending on the type of metric.
Click Save to save the metric and its formatting.