When creating or editing a List: Basic or List: Time Series report, you can assign conditional background colors for numeric fields in the report. To do this, click on the gear icon for the field in the Data tab of the Report Designer. This will open the Edit Settings dialog.
The Edit Settings dialog has 2 tabs: General and Colors. The Colors tab is available only for percent and numeric fields.
- The General tab is where you edit the Display name of the field and configure field-level filters.
- The Colors tab is where you create a conditional background colors for numeric fields. If a custom color already exists, you can reuse it. When you click the color tab, you'll see three or four menu options (see below) - by default, background colors are not displayed (Do Not Show).
Setting Up a Custom Conditional Background Color
When you select Custom colors from the drop list, the following modal appears. Configure the color as described below:
Show background colors: Determine if and how to use color.
Maximum color value: This color initially defaults to the first color in the Organization Color Palette lookup list normally used when a field has a value. The color displays when the highest value in the Additional Color Range Values is exceeded. If no Additional Color Range Values are configured, this color will always be displayed.
Additional Color Range Values: This component allows you to configure one or more percent ranges, each of which is associated with a color.
Measurement Field: For non-percent numeric fields, provides the denominator for the calculation on the field that will result in a percentage for the color range.
Use Color Gradient: Check this box to to use a color gradient in the field background.