Conditional Formatting provides the ability to visually represent and highlight data in the grid using indicators that are based on a predefined set of criteria. For example, conditional formatting icons can be used as traffic lights that grab the user’s attention and quickly convey a status that is based on underlying detailed data within Stratum.Viewer. Icons also help the user visualize answers to the following types of questions:
What are we ahead or behind on?
What goals have been reached? Which have not?
Are we improving or getting worse?
The following are examples of views with conditional formatting.
The view below has a conditional format applied to the measure item “Gross Margin Amount.” It is defined to display a green up arrow when the margin is greater than $10,000. A yellow horizontal arrow displays if margin is between $5,000 and $10,000. A red down arrow displays if margin is below $5,000. This measure item also has been defined with a pop-up label that displays the Gross Margin Amount value as well as the criteria associated with the conditional format.
The view below has a conditional format applied to the Gross Margin Amount measure item that displays indicator icons. The Gross Margin Amount value displays in addition to the indicator icons.
The view below has a conditional format applied to the Gross Margin Amount measure item that uses cell coloring to highlight margins below a desired target of $5,000.
