Here is some information
about applying conditional highlighting to tables and graphs:
For graphs, conditional
highlighting is measure-based. The graph must include at least one
measure that can be used in the condition. For tables, conditional
highlighting is based on measures or categories. The table must include
at least one measure or category that can be used in the condition.
How conditions are evaluated
Highlighting conditions
are evaluated based on raw values. The use of raw values affects how
conditions are applied to rounded values. For example, in your table
or graph, you have formatted product prices so that they are rounded
up or down. The actual cost of a pair of Eclipse running shoes is
$49.65. In the table or graph, the $49.65 price is rounded up to $50.
If you specify that you want to highlight all products that cost less
than $50, the Eclipse running shoes are highlighted because their
actual price is less than $50.
Creating conditions for percentages
If you are creating
a condition for percentages, you must enter the conditional value
as a decimal number. For example, if you want to filter for values
above 50%, enter
.5 as the
conditional value.
In general, there are
two types of rules that you can create:
-
Rules that compare a measure to
a fixed value. For example, you might create a rule for
Sales
> 1000.
-
Rules that compare one measure
value relative to another measure value. For example, you might create
a rule for
Sales > Budget.
SAS Web Report Studio
processes these rules in the following ways:
-
For the first type of rule, the
condition is applied at the current level of the data source. For
example, if you drill down into the data and then specify conditional
highlighting, the condition applies to the level that is currently
displayed.
-
For the second type of rule, the
condition is applied at all levels of the data source, regardless
of the current level.