Create Stoplight Format page

Use this page to create a stoplight format for a worksheet item. For example, you might want to categorize sales figures as unacceptable, acceptable, and desirable.

This dialog is also displayed as:
Edit Stoplight format page

For more information, see:

"What is a conditional format?"

"What is a stoplight format?"

"Format Worksheet data links page"

"Conditional Formats (Table/Crosstab) page"

"Create Conditional Header Format page"

"Create Stoplight Format page"

Name

Use this field to specify a name for the stoplight format. The name you specify is used to identify the conditional format on other pages. To use the name that Discoverer Viewer has created, you use the value that exists in the field.

Thresholds

Use these fields to specify the ranges for the unacceptable and desirable categories.

• Unacceptable

  Use this field to enter the threshold for the unacceptable category. For example, enter 5000 to treat values of 5000 or less as unacceptable.

• Acceptable

  This read-only field is populated automatically based on the values that you enter in the Unacceptable and Desirable fields.

• Desirable

  Use this field to enter the threshold for the desirable category. For example, enter 30000 to treat values of 30000 or more as desirable.

Color

Use these icons to display the color picker, which enables you to change the color of unacceptable, acceptable, and desirable values in all stoplight formats.

Dimension

Use this read-only field to view the dimensions (for example, Year, Region, City) to which you can apply the conditional format.

Note: This field is only displayed for crosstab worksheets.

Apply Format to Members

Use this read-only field to view the selected dimension values (for example, 2002, East, Boston) to which the format is to be applied.

Note: This field is only displayed for crosstab worksheets.

Edit

Use this icon to display the Select <member> page where you select one or more dimension members that you want the conditional format to apply to. For example, if the member is City, you could select a specific city (for example, Paris) to apply the conditional format to that city when the condition becomes true.

Note: This field is only displayed for crosstab worksheets.

Note: Instead of displaying a table of dimensions whose selections you can edit, Discoverer might display a message saying that the selections cannot be changed. Discoverer displays this message under the following circumstances:

• When you have selected multiple ranges of cells.

  In this case, the selection is too complex to be identified by the dimension members for the cells.

• When the crosstab is in outline mode, where a member at a higher level of a hierarchy has its own row, apart from any of its children, and you have selected one of these rows.

  For example, when a crosstab displays rows for countries and their cities. In outline mode, Japan would have its own row, and rows for Osaka and Tokyo would appear below it. When you apply a format to the Japan row, the selection is too complex to be represented by its dimension members, because there is no value for cities.

• When the selected cells do not currently appear in the crosstab.

  For example, if a row or column for Osaka has been selected, and then you drill up so that the crosstab no longer displays cities in Japan, then the selected cells do not appear in the crosstab, and the selection cannot be edited in this page. If you drill down again in Japan, then you can edit the selection in this page

Apply format to

Use these options to specify the data points to apply the stoplight format to as follows:

• All Data Points

  Use this option to apply the current stoplight format to all Data Point values.

• Selected Data Points

  Use this option to apply the current format to one or more available Data Points. For example, if the selected data point is Profit Sum, the current format would be applied to all cells in the Profit Sum column.

Note: This field is only displayed for table worksheets.

Available/Selected

The Available field shows the Data Points in the worksheet. The Selected field shows those Data Points to which the stoplight format is to be applied.

Use these fields to move the Data Points to and from the Available and Selected fields.

Note: This field is only displayed for table worksheets.