QPR ProcessAnalyzer Table: Difference between revisions
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" } }