Pivot table traffic light guage

[smilingjohn]

Hi All,

I have to create a gauge chart with dimension Department and expression sum(Sales) 

in expression i have to show traffic lights rather than numbers .  like below  for  .Is it possible to achive this ?

Thanks in Advance 

[zhadrakas]

you can do this by

change Representation to "trafic light gauge" and click on "gauge settings"

there create your 4 segments.

Disable "autowidth Segments"

Set min and mix static if you like. to do it dynamic you can use something like this

min(aggr(NODISTINCT sum(Sales), Your_Dimension))
max(aggr(NODISTINCT sum(Sales), Your_Dimension))

Set your min values for each segment at "Lower Bound"

Set your colors for each segment

regards

tim

[smilingjohn]

Thanks @zhadrakas 

How do i add the min values to the segment it is not taking .All mi values are considering same . 

I am attaching my QVW file 

I want to show the below indication 

Cosmatics	10	Red
Choclates	20	Green
Sports	30	Yellow
Finance	10	Red
Wiring	50	orange

[zhadrakas · Accepted solution]

that should explain it