How to change "low values good" to "high valu

other Xcelsius - Crystal Dashboard Design
1

I’m very new to xCelsius (< 1 week), and I can’t find the answer to my question anywhere.

I’m using QaaWS to return data to be displayed, and I want to set up alerts on it. The idea is that there are a list of 60 indicators, and when you choose one of the indicators, another QaaWS is fired to get the last 30 days history for this indicator. This data is numeric, and is designed to be shown in a graph. Associated with each value, is a colour, Red/Yellow/Green (I can also return the low/high values if needed). What I’d like to do is then use the alerter capability to highlight the data in Red/Yellow/Green where the associated value is red/yellow/green. I tried to use the “use a range” option, and it worked for some of the indicators. Where it fell down is that while for some of the indicators, “low values are good”, for some of them “high values are good”. Without figuring if that toggle can be set dynamically, has anyone managed to achieve what I want to do? Feel free to ask me questions if you don’t follow.

I’m using xCelsius 2008 Enterprise (SP2) with Business Objects XI 3.1 (SP2.1) in the background.

An example of the data would be

Indicator #1: Value 30: Colour: Green Red Low:100 Red High: 1000 Yellow Low 40, Yellow High 99, Green Low 0 Green High 39
and 29 more entries

Indicator #2: Value 17: Colour Yellow Red Low: 0 Red High 10 Yellow Low 11 Yellow High 20 Green Low 21 Green High 100
and 29 more entries

adrian.procter :canada: (BOB member since 2006-09-26)

2

Just to be clear, are you trying to change low to high and back again based on a formula? Or are you just asking where this particular feature is for alert settings so you can set it manually…

Dave Rathbun :us: (BOB member since 2002-06-06)

3

First I don’t follow your examples at all… the colon vs comma makes it hard to figure out which parts are data elements.

But if it’s just the alerter that has you stumped…The short answer is nope… the “Low as good” vs “high” is a one time only checkbox…

However you could always use TWO charts identical except for the alert option, one over top of each other and use a dynamic display to determine which one to show based upon which item the user choose…

Items A, B, D = Display 1 with “High = Good”
Items C, E = Display 2 with “Low = Good”

That would give you the end result… you just need a method/place to store which items belong to which alerter category.

JPetlev (BOB member since 2006-11-01)

4

Sorry if my examples weren’t clear.
Let’s say I have two indicators, and for one of them I need “high values are good” and for the second, “low values are good”, I was looking for a way to set that at runtime, without knowing which indicator might be clicked on.

The suggestion to use two charts, and hide one or the other looks like it would do I want.

Thanks for that!

adrian.procter :canada: (BOB member since 2006-09-26)