QPR ProcessAnalyzer Table: Difference between revisions
Jump to navigation
Jump to search
m (Ollvihe moved page QPR ProcessAnalyzer Chart Conditional Formatting to Tables Conditional Formatting without leaving a redirect) |
No edit summary |
||
| Line 7: | Line 7: | ||
"color": "#FF0000", | "color": "#FF0000", | ||
"limit": 5, | "limit": 5, | ||
" | "comparison": "<=" | ||
}, | }, | ||
{ | { | ||
"color": "#FFFF00", | "color": "#FFFF00", | ||
"limit": 10, | "limit": 10, | ||
" | "comparison": "<=" | ||
}, | }, | ||
{ | { | ||
"color": "#00FF00", | "color": "#00FF00", | ||
"limit": 50, | "limit": 50, | ||
" | "comparison": ">" | ||
} | } | ||
] | ] | ||
| Line 50: | Line 50: | ||
"backgroundColor": { | "backgroundColor": { | ||
"color": "#FFD851" | "color": "#FFD851" | ||
} | |||
} | |||
</pre> | |||
<pre> | |||
"conditionalFormatting": { | |||
"textColor": { | |||
"rules": [ | |||
{ | |||
"color": "#FF0000", | |||
"limit": 20, | |||
"comparison": "<=" | |||
}, | |||
{ | |||
"color": "#00FF00" | |||
} | |||
] | |||
} | |||
} | |||
</pre> | |||
<pre> | |||
"conditionalFormatting": { | |||
"icon": { | |||
"rules": [ | |||
{ | |||
"icon": "star", | |||
"limit": 100, | |||
"comparison": ">" | |||
} | |||
] | |||
}, | |||
"iconColor": { | |||
"rules": [ | |||
{ | |||
"color": "#00FF00", | |||
"limit": 500, | |||
"comparison": ">" | |||
}, | |||
{ | |||
"color": "#FF0000", | |||
} | |||
] | |||
} | |||
} | |||
</pre> | |||
<pre> | |||
"conditionalFormatting": { | |||
"databar": { | |||
"min": 0, | |||
"max": { "type":"dimension", "index": 1, "aggregate": "min" } | |||
"direction": "right" | |||
} | } | ||
} | } | ||
</pre> | </pre> | ||
Revision as of 16:45, 20 June 2020
"conditionalFormatting": {
"backgroundColor": {
"rules": [
{
"color": "#FF0000",
"limit": 5,
"comparison": "<="
},
{
"color": "#FFFF00",
"limit": 10,
"comparison": "<="
},
{
"color": "#00FF00",
"limit": 50,
"comparison": ">"
}
]
}
}
"conditionalFormatting": {
"backgroundColor": {
"scale": [
[{ "aggregate": "min" }, "#FFFFFF"],
[{ "aggregate": "max" }, "#FFD851"],
]
}
}
"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"
}
}