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
by using the gauge chart to implement the green and red symbols