Difference between revisions of "Color Code"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
This conditional color code function highlights rows based on the user-defined conditions in | This conditional color code function highlights rows based on the user-defined conditions in [[Reports]]. Any number of conditions can be added to color your data. Records that match specified criteria are displayed with the selected background color. | ||
;Considerations: | |||
:* Color coding applies to Tabular Reports only, not Matrix or Chart Reports. | |||
== How it works == | == How it works == | ||
| Line 8: | Line 9: | ||
#Define a true/false condition | #Define a true/false condition | ||
#Choose a color from the color palette | #Choose a color from the color palette | ||
Up to 10 conditions can be specified. | |||
A typical condition might be <tt>"Status is equal to In Progress"</tt>, or <tt>"Expected Revenue is greater than $1000"</tt>. | A typical condition might be <tt>"Status is equal to In Progress"</tt>, or <tt>"Expected Revenue is greater than $1000"</tt>. | ||
Latest revision as of 23:40, 12 June 2014
This conditional color code function highlights rows based on the user-defined conditions in Reports. Any number of conditions can be added to color your data. Records that match specified criteria are displayed with the selected background color.
- Considerations
-
- Color coding applies to Tabular Reports only, not Matrix or Chart Reports.
How it works
- Select a data field
- Define a true/false condition
- Choose a color from the color palette
Up to 10 conditions can be specified.
A typical condition might be "Status is equal to In Progress", or "Expected Revenue is greater than $1000".
When the condition is true, that row will be highlighted in the color you choose.
Exceptions
Some field types cannot be used for color coding, including:
- Lookups and Related to Lookups
- Dependent Multi-Fields
- Multi-Checkbox
- Multi-Picklists
- Rich Text Areas
- File and Image fields
- Multi-Select Lookups