Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am trying to create an Heat map with below requirement.
If 1<Sum(Measure)<=0.75 then the cell should be green
0.75<Sum(Measure)<=0.5 then the cell should be Yellow
0.5<Sum(Measure)<=0.1 then the cell should be Red
Other values should left out with Grey.
When I have tried to create I could see different colors are being applied in the cell background.
I have attached the data and Sample app. Could you please check and help me in getting this done.
Thanks
S k
Have you tried like:
=If( 1<Sum(Measure) and Sum(Measure)>=0.75, green(),
if(Sum(Measure)>=0.5, yellow(),
if(Sum(Measure)>=0.1, lightred())))
How is your expected result different from what you already have achieved?