Gauge Graph with 3 segments

[helen_pip]

Hello

I have attached a QVW which shows a gauge graph

In the gauge graph I have 3 segments on the presentation tab

I can only get 2 segments to show at the moment. 

Could someone help me show the 3rd and in addition I would like the gauge graph to show Green, then grey and finally red, and am not sure how to achieve this

Thanks

Helen

[#2 · Accepted solution]

You must change the Lower Limit of your last segment (the one you call Segment 2) to the sum of the both criterias:

=Count({<CRITERIA={'1) Dated - in time', '2) No date'}>} Identifier) / Count(Identifier)

The way you did it before, the last segment limit was smaller than the second one.

Juan Gerardo

[Gysbert_Wassenaar]

See attached qvw. Is that what you mean?

[helen_pip]

Thank you!

This works perfectly

Thanks

Helen

[helen_pip]

Hello

Thanks for your help I have foudn it very useful and you too had the correct answer which has really helped me

Thanks

Helen