QPR ProcessAnalyzer Table

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

• backgroundColor
• textColor

rules scales

Example: Background color is based on the data values:

{
	"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 is #FFFFFF and maximum value is #FFD851.

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

Example: Background color is based on a color scale.

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

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

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

"conditionalFormatting": {
	"icon": {
		"rules": [
		{
			"icon": "star",
			"limit": 100,
			"comparison": ">"
		}
	]
	},
	"iconColor": {
		"rules": [
		{
			"color": "#00FF00",
			"limit": 500,
			"comparison": ">"
		},
		{
			"color": "#FF0000",
		}
	]
	}
}

"conditionalFormatting": {
	"databar": {
		"min": 0,
		"max": { "type":"dimension", "index": 1, "aggregate": "min" }
		"direction": "right"
	}
}