Traffic light indicator in straight table

[grajmca_sgp123]

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

[MK_QSL]

What is the color criteria?

[Anonymous]

Hi,

when the traffic light should be red/Yellow/green?

Can you post a qwv sample data?

Regards.

[maxgro · Accepted solution]

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

[grajmca_sgp123]

Hi Here below is the color criteria.

Greater than equal 35     -> Red

Between -20  to   35    -> Yellow

Lessthan equal  to -21 -> Green

[MK_QSL]

Sample file enclosed....

[grajmca_sgp123]

Thank you but i did not get succeeded what is the min and max you set it?

[MK_QSL]

Set Min -999 and Max 999

[grajmca_sgp123]

Thank you all finally understand the logic and implemented it correctly .

[MK_QSL]

Please close the thread by selecting appropriate answer..