Adding Table-Level Display Rules :: SAS(R) Visual Analytics 6.2: User's Guide

Add Display Rules to a List Table Using an Expression

Note: Display rules cannot be added to crosstabs.

To specify a new display rule for a table using an expression:

If it is not already selected, select the table in the report canvas that you want to update.
In the right pane, click the Display Rules tab. Click New. The Add New Display Rule window is displayed.

Add New Display Rule Window for Tables
Click Expression. The Add New Display Rule window expands to show the details for the expression.

Add New Display Rule Window for an Expression
Select the Column or any measure value.
Select the Operator. You can select =, < >, Between, <, <=, >, >=, Missing, or NotMissing. The default is >.
Enter or select a Value.
Modify the style, size, and color of the font.
Select the row or column in the Applies to drop-down list.
Click OK. The table updates with the new display rule. The display rule appears on the Display Rules tab in the right pane.

Here is an example of a display rule that uses an expression:

Display Rules Tab with the Display Rules for an Expression
(Optional) Click on the Display Rules tab to edit the new display rule.

To specify a new display rule for a table using a gauge:

If it is not already selected, select the table in the report canvas that you want to update.
In the right pane, click the Display Rules tab. Click New. The Add New Display Rule window is displayed.
Click Gauge. The Add New Display Rule window expands to show the details for the gauge.

Add New Display Rule Window for a Gauge
Select a Gauge type from the drop-down list. Your choices are a bullet, an icon, a slider, or a thermometer. Icon is the default.
Using the Based on column drop-down list, specify which column the rule should be based on in the report.
Specify where the gauge should appear in the column for the Cell placement. Your choices are Left of text, Right of text, or Replace text.
Define the intervals and colors for the rule:
- Enter the individual values for the intervals and then select a color. You can click the operator between the intervals to change it.
- Click to automatically populate the intervals. The Populate Intervals window is displayed.
  
  Populate Intervals Window
  
  You can specify Number of intervals, Lower bounds, and Upper bounds. Click OK.
Specify the Column in which you want the gauge to be displayed
Click OK. The table updates with the new display rule. The display rule appears on the Display Rules tab in the right pane.

Here is an example of an automatically populated display rule that uses an icon:

Display Rules Tab with the Display Rules for an Icon
(Optional) Click on the Display Rules tab to edit the new display rule.

To specify a new display rule for a table using color-mapped values:

If it is not already selected, select the table in the report canvas that you want to update.
In the right pane, click the Display Rules tab. Click New. The Add New Display Rule window is displayed.
Click Color-mapped values. The Add New Display Rule window expands to show the details for the color-mapped values.

Add New Display Rule Window for Color-Mapped Values
Select the Column or value to which you want to apply the display rule.
Click in the box to enter a value for the display rule.
Select a color for the display rule.
(Optional) Repeat the steps for entering a value and selecting a color.
(Optional) Select the Other check box. Then, select a color.
Using the Applies to drop-down list, specify where you want to apply the colors.

In the following example, values and colors have been specified for products in a list table.

Add Display Rule Window with Color-Mapped Values Displayed
Click OK. The table updates with the display rules.

The display rule appears on the Display Rules tab in the right pane.

Display Rule for Color-Mapped Values
(Optional) Click on the Display Rules tab to change the table-level display rule to a report-level display rule.