Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you please send some sample file.
Have you written below color coding
if([Gw%] >=40 ,Red(),
if([Gw%] >20 ,Green(),
if([Gw%] >20 and [Gw%] <40 ,Yellow())) )
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
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() ))
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
The report has been attached as sample and the method used to implement was also mentioned above.
Please suggest some method
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.
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.
can you please brief me how should be incorporated ? please clarify on how to make changes