Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Phil,
the sample file "Data Visualization" has a Speedometer example with RAG (KPI Tab>>Presentation property>>Segments)
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
pfa image
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 :
Please Find sample Give in Text Colour.
Vikas