percentage color change

[ssriramin19]

Hello

There are three color coding being used in the chart.

If the percentage is less than 20  background color used in green

if the percentage is greater than 40 then the back ground is red

if the percentage is between 20 and 40 then it should be yellow

My requirement is that

There are values more than hundred percentage .As per the above logic the values being displayed are in red in color . but what is need is that  similar to above

if it is from 120 to 140 then it should  yellow

if it is less than 120 it should be green 

if it is greater than 140 it should be red

it should not be only for values of 100 but it should be for all the values 200, 300, 500 etc,.

How this needs to be achieved?

Please suggest some technique on this

Thanks

Sriram

[prma7799]

Can you please send some sample file.

[prma7799]

Have you written below color coding

if([Gw%] >=40    ,Red(),

if([Gw%] >20 ,Green(),

if([Gw%] >20 and [Gw%] <40 ,Yellow())) )

[santhosh_k_n]

Hi,

Do this need to implemented in table box/straight table or any other chart?

And you can apply this conditions in the Background color attribute option available after expanding(click on +symbol) the expression in the expression tab.

BR,

SK

[avinashelite]

did not get your exact requirement , Try like this:

if(right(your_Percentage_column,2)>20 or right(your_Percentage_column,2)<40,yellow(),if(right(your_Percentage_column,2)<20,green(),red() ))

[ssriramin19]

The color coding was given in visual clues . for all the three colors.

in the visual cues the percentage and color variation is given as

[ssriramin19]

The report has been attached as sample  and the method used to implement was also mentioned above.

Please suggest some method

[prma7799]

You can give multiple color combination using below step.

Go to expression> select the expression which you want to change color > select + sing >text color.

[#9]

Hi Sriram,

You can try the below expression in Background Color

if(Sum (percentage)<120, Green(),if(Sum (percentage)>=120 and Sum (percentage)<=140,Yellow(),if(Sum (percentage)>140,Red())))

Kindly let me know if its working.

[ssriramin19]

can you please brief me how should be incorporated ? please clarify on how to make changes