QPR ProcessAnalyzer Table
Jump to navigation
Jump to search
Table conditional formatting is defined as a JSON object with following properties:
- backgroundColor
- textColor
- rules: rules are check in their order and the first matching determines the color.
- color
- limit
- comparison: <, >, <=, >=, ==, !=
- scales
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": [ [{ "aggregate": "min" }, "#FFFFFF"], [{ "aggregate": "max" }, "#FFD851"] ] } }
Example: Similar to previous example, except minimum and maximum values come from another column (measure number 1).
{ "backgroundColor": { "scale": [ [{ "type":"measure", "index": 1, "aggregate": "min" }, "#FFFFFF"], [{ "type":"measure", "index": 1, "aggregate": "max" }, "#FFD851"] ] } }
The following setting defined a fixed color for the column.
{ "backgroundColor": { "color": "#FFD851" } }
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" } ] }, "iconColor": { "rules": [ { "color": "#36d475", "limit": 100, "comparison": ">" }, { "color": "#EF5254" } ] } }
{ "databar": { "min": 0, "max": { "aggregate": "max" } } }