Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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 ))))
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.
hi
ok what about to aggr your color coding by Status ?
aggr(
if([Measure] > .8, Green(), if([Measure] < .3, Yellow(), 'Navy')),
Status )
?