Here is some information
about applying conditional highlighting to tables and graphs:
Requirements
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.
Using category values for conditional highlighting
Highlighting on category values is always case sensitive. You might need to create
more than one conditional
highlighting rule to account for all the variations of a value.
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.
Creating rules
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.