The Color Range Column

The Color Range Column element, introduced in v12.6, adds new columns, containing color values that are correlated to data, to a datalayer. This allows you to dynamically set the background and text colors in individual Data Table cells.

The following topics introduce the Color Range Column element:

• Color Range Column Attributes
• Color Range Column Usage Examples: Numeric Data
• Color Range Column Usage Examples: Text Data

About the Color Range Column

The Color Range Column is similar to other elements designed to extend the data available in a datalayer. It's added as a child element beneath a datalayer and adds a two new columns to the datalayer. These column values are derived data, accessible using @Data tokens.

The new columns' values result from testing other column data values against specified ranges, for each row in the datalayer, and correlating them to specified color values. These color values populate the new columns in every row of the datalayer and, via their @Data tokens, can be used to dynamically set background and text color values for each Data Table cell.

When definitions using Color Range Columns are exported to Excel or to PDF, the Data Table cell text and background colors are exported as well.

Each Color Range Column element evaluates one other data column; multiple Color Range Column elements can be used, if needed.