Color Coding

[ColtE8]

I have a bar graph with multiple rows. The rows show a certain percentage of completion. Within these percentage of completions are different status for each row. Something could be 100% complete but not labeled "Validated" and the next one down could be 100% complete AND labeled "Validated". I need the graph to color code these different. The criteria could be something like this:

     100% and Status is Validated: Green

     100% but Status is NOT Validated: Navy

     Status is Implemented: Orange

     Status is Developed: Yellow

So I have this right now:

if([Status] = 'Validated', 'green', if([Status] = 'Developed', 'yellow', 'navy'))

This isn't even working to begin with and I don't know where else to take this. Please help!

[brunobertels]

hi 

may be this 

if( YourMesure='100%' AND [Status] = 'Validated', green() , 

if(YourMesure='100%' AND [Status] =- 'Validated', lightblue(), 

if([Status] = 'Implemented' , orange , 

if([Status] = 'Developed' , Yellow )))) 

[ColtE8]

Ya that's not really working either 😕

Right now the best I can get is:

if([Measure] > .8, Green(), if([Measure] < .3, Yellow(), 'Navy'))

So now anything above 80% is green, between 30% and 80% is Navy, lower than 30% is yellow. It's not the fix to the issue though. I still would like the color to change if that actual status is different.

[brunobertels]

hi 

ok what about to aggr your color coding by Status ? 

aggr(

if([Measure] > .8, Green(), if([Measure] < .3, Yellow(), 'Navy')),

Status ) 

?