QPR ProcessAnalyzer Table: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
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:
<pre>
<pre>
{
{
Line 24: Line 31:
</pre>
</pre>


Example: Background color is based on a color scale where column minimum value is #FFFFFF and maximum value is #FFD851.
<pre>
<pre>
"conditionalFormatting": {
"conditionalFormatting": {
Line 35: Line 43:
</pre>
</pre>


Example: Background color is based on a color scale.
<pre>
<pre>
"conditionalFormatting": {
"conditionalFormatting": {

Revision as of 17:08, 21 June 2020

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"
	}
}