Search code examples
conditional-formattingobieegauge

OBIEE - Conditional Formatting of Gauge


I am helping build an analysis which uses a series of gauges to provide a visual indication of how full certain quotas are.

For a few of these, the values are actually over-budget but the gauges are meaningless to look at as the needle has disappeared. Example - Maud's budget is 4 but is over-budget (actual value is 7). Aside from the fact I've added a label to indicate this, the gauge is pretty meaningless:

enter image description here

Ideally, I'd love to be able to introduce conditional formatting so that if things are over budget it stands out - for example:

enter image description here

I can't see a way of doing this - as conditional formatting seems to be limited to columns which affects how data is displayed in a pivot table ...

Is this type of conditional formatting for a gauge even do-able?!


Solution

  • No, sorry, the charting engine doesn't support this out-of-the-box