How to define Gauge Chart Segment Setup Color

[Anonymous]

Hi

      How to define Gauge Chart Segment Setup Color.

     Ex. actual amount show red and budget show Green. How to define this two color in Segment Setup.

Thanks.

[Anonymous]

please find below screen shot, for your reference.

[jeroen_wagner]

You can place that formula in the variable

[avinashelite]

Sathish, I didn't get your exact requirement...

See in Gauge you can show one value at a time i.e sum(sales) or Sum(budget) but not both at the same time

The Gauge segment if you have  define  as 1 to 100 then  you can say 1 to 50 is RED and 50 to 100 is gree, for eg if sum(sales ) is 10 then it will show in read segment . similarly you need to create separate gauge for sum(budget) 

[avinashelite]

Hi Sathish,

I didn't get your exact requirement...

See in Gauge you can show one value at a time i.e sum(sales) or Sum(budget) but not both at the same time

The Gauge segment if you have  define  as 1 to 100 then  you can say 1 to 50 is RED and 50 to 100 is gree, for eg if sum(sales ) is 10 then it will show in read segment . similarly you need to create separate gauge for sum(budget) 

[avinashelite]

I didn't get your exact requirement...

See in Gauge you can show one value at a time i.e sum(sales) or Sum(budget) but not both at the same time.

The Gauge segment if you have  define  as 1 to 100 then  you can say 1 to 50 is RED and 50 to 100 is gree,

for eg if sum(sales ) is 10 then it will show in read segment . similarly you need to create separate gauge for sum(budget)

[Anonymous]

Thanks for Support.we will do the Same.

[avinashelite]

if you have got the answer , please mark the correct answer and close this thread

[jeroen_wagner]

Look at the example I sent you Yesterday Sathishkumar

(Presentation tab)

Color:   RGB(254*($(vValue)/100),150,150)

Segment2 Lower limit:  $(vValue)

[Anonymous]

Hi Arvinsh,

     we can't fix 1 to 50 is red an 51 to 100 is Green.this value floating.In this value displayed by calculation.

Ex:

          Actual : 100

          Budget :150

  Gauge Chart Needle Show 75% this is ok.

We need to display Lower Bound Color,  Then 75% display red color  and 75 to 100% Green Color.

I think this is better understanding.

Thanks.

[Anonymous]

No.we need to provide lower bound value based on Calculation.

Ex:

          Actual : 100

          Budget :150

  Gauge Chart Needle Show 75% this is ok.

We need to display Lower Bound Color,  Then 75% display red color  and 75 to 100% Green Color.