QPR ProcessAnalyzer Table

Table conditional formatting is defined as a JSON object with following allowed properties:

• backgroundColor / textColor / iconColor / databarColor
  • rules
  • scale
  • color: To define a fixed color.
• databar
  • min
  • max
  • color
• icon
  • rules
  • color

• rules: rules are check in their order and the first matching determines the color.
  • color
  • limit
  • comparison: <, >, <=, >=, ==, !=
• scale
  • color
  • value

Example: Background color is based on the following rules:

• if value is lower or equal to 5, background color is #FF0000
• if value is between, 5 and 10, background color is #FFFF00
• if value is greated than 10, background color is #00FF00

{
	"backgroundColor": {
		"rules": [
			{
				"color": "#FF0000",
				"limit": 5,
				"comparison": "<="
			},
			{
				"color": "#FFFF00",
				"limit": 10,
				"comparison": "<="
			},
			{
				"color": "#00FF00",
				"limit": 50,
				"comparison": ">"
			}
		]
	}
}

Example: Background color is based on a color scale where column minimum value gets color #FFFFFF and maximum value #FFD851. Color is scaled linearly between these colors.

{
	"backgroundColor": {
		"scale": [
			{
				"value": { "aggregate": "min" },
				"color": "#FFFFFF"
			},
			{
				"value": { "aggregate": "max" },
				"color": "#FFD851"
			}
		]
	}
}

Example: Similar to previous example, except minimum and maximum values come from another column (measure number 1).

{
	"backgroundColor": {
		"scale": [
			{
				"value": { "type":"measure", "index": 1, "aggregate": "min" },
				"color": "#FFFFFF"
			},
			{
				"value": { "type":"measure", "index": 1, "aggregate": "max" },
				"color": "#FFD851"
			}
		]
	}
}

The following setting defined a fixed color for the column.

{
	"backgroundColor": {
		"color": "#FFD851"
	}
}

{
	"backgroundColor": {
		"color": { "type":"measure", "index": 1 }
	}
}

Rules are applied to the text color.

{
	"textColor": {
		"rules": [
			{
				"color": "#FF0000",
				"limit": 20,
				"comparison": "<="
			},
			{
				"color": "#00FF00"
			}
		]
	}
}

{
	"icon": {
		"rules": [
			{
				"icon": "sentiment_satisfied_alt",
				"limit": 100,
				"comparison": ">"
			},
			{
				"icon": "sentiment_very_dissatisfied"
			}
		],
		"color": {
			"rules": [
				{
					"color": "#36d475",
					"limit": 100,
					"comparison": ">"
				},
				{
					"color": "#EF5254"
				}
			]
		}
	}
}

{
	"databar": {
		"min": 0,
		"max": { "aggregate": "max" },
		"color": {
			"scale": [
				{
					"value": 0,
					"color": "#FFFFFF"
				},
				{
					"value": { "aggregate": "max" },
					"color": "#FFD851"
				}
			]
		}
	}
}