Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am trying to design a Traffic Light Gauge chart and show Green , Yellow and Red lights based on the VPQ field. below is my data source.I know the properties where we can create Traffic Light signals.
in Chart Properties --> Expressions --> Dispay Options --> Representation --> Traffic Light Gauge.
but I am unable to set the min and max values for negative and positive values.
Q1'15 | Q2'15 | VPQ | ||
Critical | ||||
702 | 149,012.00 | 297,171.00 | 99% | Red indicator |
701 | 40,334.46 | 163,359.00 | 305% | RED indicator |
711 | 758,563.64 | 746,340.86 | -2% | Yellow indicator |
712 | 256,640.84 | 288,912.64 | 13% | Yellow indicator |
Component | ||||
501 | 2,190,832.00 | 133,596.00 | -94% | green indicator |
502 | (2,727,808.04) | (24,504.00) | -99% | green |
702 | 26,813,560.37 | 3,026,948.03 | -89% | green |
701 | 11,552,657.65 | 2,179,616.26 | -81% | green |
711 | 3,973,379.22 | 727,615.97 | -82% | green |
712 | 4,141,657.84 | 900,335.75 | -78% | green |
Can you please suggest how we can set min and max values to get respective traffic light indicators.
Thanks in advance
I used
-999 for lower bound of Segment1
-0.05 " Segment2
0.5 " Segment3
also my VPQ is VPQ / 100
but this is just an example to get the output you want
What is the color criteria?
Hi,
when the traffic light should be red/Yellow/green?
Can you post a qwv sample data?
Regards.
I used
-999 for lower bound of Segment1
-0.05 " Segment2
0.5 " Segment3
also my VPQ is VPQ / 100
but this is just an example to get the output you want
Hi Here below is the color criteria.
Greater than equal 35 -> Red
Between -20 to 35 -> Yellow
Lessthan equal to -21 -> Green
Sample file enclosed....
Thank you but i did not get succeeded what is the min and max you set it?
Set Min -999 and Max 999
Thank you all finally understand the logic and implemented it correctly .
Please close the thread by selecting appropriate answer..