Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
i'm trying to plot states in geo analysis in same color - green . and i wants to give condition : if emp count is more then 0 and less the 100 then color should be light green , and if count is more then 100 and less then 200 then color should be dark green and if count is more then 300 then color should be super dard
now im using this script
=if(COUNT(ProjectID) > 0 AND COUNT(ProjectID) < 100, argb(64, 255, 0, 0),
if(COUNT(ProjectID) >= 100 AND COUNT(ProjectID) < 200,argb(128, 255, 0, 0),
if(COUNT(ProjectID) >= 200 AND COUNT(ProjectID) < 300, argb(192, 255, 0, 0),
if(COUNT(ProjectID) >= 300,argb(255, 255, 0, 0) ))))
simplify this
=if(COUNT(ProjectID) > 0 and <100 , argb(64, 255, 0, 0),
if(COUNT(ProjectID) >= 100 AND < 200,argb(128, 255, 0, 0),
if(COUNT(ProjectID) >= 200 AND < 300, argb(192, 255, 0, 0),
if(COUNT(ProjectID) >= 300,argb(255, 255, 0, 0) ))))
=if(COUNT(ProjectID) > 0 AND COUNT(ProjectID) < 100, RGB(0,255,0),
if(COUNT(ProjectID) >= 100 AND COUNT(ProjectID) < 200,RGB(0,64,0),
if(COUNT(ProjectID) >= 200 AND COUNT(ProjectID) < 300, RGB(0,64,128),
if(COUNT(ProjectID) >= 300,RGB(64, 0, 0) ))))
Use colormix wizard
my requirement is only green , i mean coordinator to count color should be reflect light green to dark gree
=if(COUNT(ProjectID) > 0 AND COUNT(ProjectID) < 100, RGB(0,255,0),
if(COUNT(ProjectID) >= 100 AND COUNT(ProjectID) < 200,RGB(0,170,0),
if(COUNT(ProjectID) >= 200 AND COUNT(ProjectID) < 300, RGB(0,108,0),
if(COUNT(ProjectID) >= 300,RGB(0,64, 0) ))))
What exactly is the issue you are facing? Is the if statement not working? Is it very slow?
Argb function get this vars -> ARGB(Alpha, Red, Green, Blue). Use RGB function RGB(Red, Green, Blue).