Visual Cues Query

[Anonymous]

Hi

I want to set a RAG status for few thresholds using Visual Cues, could someone point me in the right direction.  I am sure this will be simple, just can't find it on the forum.

My expression is a percentage and I need it to show as below:

Less than 80% =                      Red

80% - 94.9% =                         Yellow

95% - 99.9% =                         Green

100% - 104.9% =                     Yellow

More than or equal to 105% =   Red

Any ideas??

Thanks

Phil

[jpenuliar]

Hi Phil,

the sample file "Data Visualization" has a Speedometer example with RAG (KPI Tab>>Presentation property>>Segments)

[vikasmahajan]

While define visual cues , click on expression window and use if condition like this

if  (growth > 80 and growth < 94.9 , Yellow(),if( growth >  and <  , Green() , If(

This should solve your problem

Vikas

[vikasmahajan]

pfa image

[Anonymous]

Vikkas

Your script works but it returns the text of the colour ('RGB, 255,255,0') text, not the percentage and the colour.

Please see below :

[vikasmahajan]

Please Find sample Give in Text Colour.

Vikas