Dynamically changing Max/Min values in Gauge

[Skykit]

Hi all,
New to SDK - got a requirement to be able to dynamically change min/max values as well as gauge tolerance (red/amber/green) - does anyone have anything that already exists or can point me to the right direction?

The problem is that the data gets loaded multiple times a day and each time, the range of the gauge changes - because of this, someone manually is having to increase/decrease the max value for a gauge.  This is the same for the tolerance which is based on a calculation in the load.

Appreciate any help!
Thanks

[CognosPaul]

I once had a similar problem. The user requirements were to see several gauges, and to be able to slice by time, country, and so on.

While you can't dynamically set the min/max values, or the tolerances, you can cheat. Set the max value to 1.5, and set the measure to a percentage. The tolerances of the gauge should set to something like red <0.3, yellow <0.7, green 1.2, blue >= 1.2.

For example, I had a measure of products sold and target. On a year level the products sold was, lets say, 500. On a month it could be 30. The target was 400. The measure on the gauge was [Sold]/[Target]. No matter how the user sliced the data, the gauges were always appropriately proportional to the data.

[Skykit]

Thanks Paul,

We sat down and worked with a pen and paper to work out your solution but it won't work for us - I think while we both need/ed dynamic values, both our scenarios are different in the way data is brought in.

So to expand on my own issue:

We have the following going in 6 times (for 6 different gauages)
Actuals   Manual figure that is changed x times a day
Budget : Manual figure that is changed x times a day
Green: Calculated as Target - 7%
Red  : Calculated as Budget - 15%
Max  : Calculated as 2 * Budget

The two needles are the Actuals and Budget

The red and green values are calculated and are in the table of where the figures load in (as above)

So as an example:

Actuals: 7562
Budget: 17356
Green: 16141
Red: 14753
Max: 34712

Actuals/Budget (Needles) would automatically appear as these tie in with the framework model/database table
The green red and max have to be set manually each time the load goes in as these are based on the needle values.


My thoughts are:
Extract the XML from the content store
Have a front end that links to the specific nodes to that gauge
The front end would be used to enter the values, hit submit and this updates the database and also shoots out the 3 values to XML file and then "updates" wherever it is stored in the content store.


What do you think?

Thanks again!

[CognosPaul]

At this point I'm out of ideas. I have no experience at all with the SDK so I don't know if I'll be any more help. Good luck though.