Gauge chart with count and date

[#1]

Hi All

Can you please help me how we configure a Gauge chart for the below scenario

Total number of open request

1. If the count request is less than < 10 it should be in green
2. If the count request is more than < 10 and less than 50 it should be in yellow
3. If the count request is more than < 50  it should be in red

and similar with created date

1. If the created date of request is less than < 10 days  it should be in green
2. If the created date of request more than < 10 and less than 15 days  it should be in yellow
3. If the created date of request more   < 50  it should be in red

[sushil353]

Hi,

1. Create the expression for your count.

2. Presentation tab> set Min as 1 and max say 100

3. uncheck Autowidth segment from lower left corner

4. Create three segment with the relevant color having lower bound as

Segment 1 --> 0

Segment 2--> 10

segment 3 --> 50

HTH

Sushil

[#3]

Thanks Sushil.Your suggestion was great help  .Can you please help with Create date scenario also.