Grid

A two-dimensional grid with optional row-level color highlighting

Features

In a grid, you can configure the columns, colors, and fonts for a defined query. You can set multiple conditions and colors for each row in the Color Context page. Multiple conditions in the MatchColumns list are matched using AND.

Example

Sample data returned from a query template is as follows:

Month	Plant	Region	Production Quality	Energy Consumption
Jan	Plant-USA	America	61.00	55
Feb	Plant-USA	America	64.00	50
Mar	Plant-USA	America	63.00	49
Apr	Plant-USA	America	75.00	56
Jan	Plant-Germany	Europe	91.00	55
Feb	Plant-Germany	Europe	92.00	51
Mar	Plant-Germany	Europe	93.00	58
Apr	Plant-Germany	Europe	94.00	56
Jan	Plant-Italy	Europe	91.00	58
Feb	Plant-Italy	Europe	92.00	55
Mar	Plant-Italy	Europe	93.00	50
Apr	Plant-Italy	Europe	94.00	56
Jan	Plant-Japan	AsiaPacific	77.00	55
Feb	Plant-Japan	AsiaPacific	79.00	60
Mar	Plant-Japan	AsiaPacific	77.00	52
Apr	Plant-Japan	AsiaPacific	79.00	58

The configurations are as follows:

1st row: RGB(153,255,102) String:EXACT_MATCH:Jan String:EXACT_MATCH:Plant-USA
2nd row: RGB(255,51,102) String:EXACT_MATCH:Feb String:EXACT_MATCH:Plant-Germany

Considering the data mentioned in the table and configurations, the following grid displays the quarterly production quality and energy consumption of a country within a region. Note that entire row that matches the condition is highlighted with the colors defined in the Color Context.

This graphic is explained in the accompanying text.

Graphical representation of Grid