Conditional Formatting

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Dashboards and Reports Customization Guide > Designing Dashboards > Dashboard Items Settings > Cards 

Conditional Formatting

For the Card dashboard item, you can apply conditional formatting to the card's visual elements (like Title, Subtitle, various values) and change the card's background.

 

wddConditionalFormatting

 

papercliper

Note:

Cards that use a legacy layout do not support conditional formatting.

 

Supported Format Rules

Format rules that can be applied to different data item types are as follows:

 

numeric

oValue

oTop-Bottom

oAverage

oExpression

oIcon Ranges

oColor Ranges

oGradient Ranges

string

oValue (with the condition type set to Equal To, Not Equal To or Text that Contains)

oExpression

date-time

oValue

oA Date Occurring (for dimensions with a continuous date-time group interval)

oExpression

oIcon and Color Ranges

oColor Ranges

oGradient Ranges

 

Refer to the following topic for more information about format condition types: Conditional Formatting in Web Dashboard.

 

Create and Edit a Format Rule

You can create and edit format rules in the Conditional Formatting section that is located in the following places:

 

The dashboard item's Options menu

The data item menu

 

Refer to the following topic for information on how to create and edit format rules: Conditional Formatting in Web Dashboard.

 

Card-Specific Format Condition Settings

For a Card dashboard item, you can apply conditional formatting to the card's visual elements (like Title, Subtitle, different values) and change the card's background.

 

Available settings in the Common section depend on the selected Calculated by option:

 

The Card option specifies a data item container. The format rule is calculated based on the card's values. The Value Type option specifies the card's measurement upon which a condition is calculated.
If the Card dashboard item contains multiple values in data item containers (cards), make sure you apply a format rule to the active card to see changes. Click Layersitem in the dashboard item caption to switch between cards. The expression format rule ignores the specified card and is applied to all cards regardless of the specified value.

For the Data Item option, you can choose a hidden measure or series dimension. The rule applies to all cards in a Card item.

 

conditionalformattingcarddeltacommon

 

To apply the selected appearance to the Title, Subtitle, values, and other card layout elements, use the Apply to drop-down list. The All elements value applies the format rule to all card elements.

 

If you select a background color, it applies to the entire card and the Apply to value is not in effect.

 

Conditionalformattingcard

 

Some predefined background styles contain a font color. This font color applies to all the card elements regardless of the drop-down list settings (all/particular element).