QPR ProcessAnalyzer Table

From QPR ProcessAnalyzer Wiki
Revision as of 08:53, 24 June 2020 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

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

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