Guage range

[soniasweety]

Hi all,

I want to show gugae chart based on range

My req below

100% guage should be used but green/yellow/red ranges should be as follows:

Green = 0 to 5%

Yellow = 6% to 15%

Red = 16% to 100%

Red = 16% to 100%

PFA.

[tresesco]

Like this?

[soniasweety]

Thanks Tres,

But if want through an Expression how can i achieve this?

suppose same values for background colour  ?how can i write the expression?

[tresesco]

Not really clear to me. Please explain a bit more, may be with a case.

[soniasweety]

i want to show the colour  based on range which i mentioned above.  for that i need to write IF condition?

how to do ?

like below:

if(sum(sales  

Green = 0 to 5%

Yellow = 6% to 15%

Red = 16% to 100%

)                     i need to  IF condition.

[rubenmarin]

Hi sony, If you want all of the same color you can keep only 1 segment and use conditional color to set the color of the segment, the conditional color expression can be:

If(expression<0.05, RGB(0,255,0),

If(expression<0.15, (255,255,0), RGB(255,0,0)))

[tresesco]

In the bar chart, right?

[soniasweety]

yes tres.

[tresesco · Accepted solution]

try:

If((Sum([Year Salary])/Sum(total [Year Salary]))<=0.05, Green(),

  if((Sum([Year Salary])/Sum(total [Year Salary]))<=0.15, Yellow(), red()))

[soniasweety]

Thnks. its working fine