6 Replies Latest reply: Jul 5, 2016 8:28 AM by Lauren Mills

# Color by Expression Problem

Hello,

Todays challenge....

Dimension = BC (ex: A B C D)

Measures =

1) Level 0 YES - SUM(Aggr(If(\$(vLevel0Completion) = 'Y', 1, 0),[SID]))

2) Level 0 NO - SUM(Aggr(If(\$(vLevel0Completion) = 'N', 1, 0),[SID]))

I would like the Level 0 YES to be green in the visual below and Level 0 No as red. Please note that my measures are based off of variables.  Let me know if you have any ideas. Thanks!

• ###### Re: Color by Expression Problem

Still looking for help on this problem. Does anyone have any idea?

• ###### Re: Color by Expression Problem

Hi

may be like this

[measure names]:

measure

Level 0 YES,

Level 0 NO

]

2 then create a master mesure like this and call it Mymeasure

if(measure='Level 0 YES',SUM(Aggr(If(\$(vLevel0Completion) = 'Y', 1, 0),[SID])),

if(mesure='Level 0 NO',SUM(Aggr(If(\$(vLevel0Completion) = 'N', 1, 0),[SID]))))

dim =BC

dim = measure

measure = Mymesure (you pick your master mesure or copy past this above)

then in the color panel select by expression and add this

if(measure='Level 0 YES',green(),

if(mesure='Level 0 NO',lightred()))

hope it helps

• ###### Re: Color by Expression Problem

Thank you!! Let me try this!

• ###### Re: Color by Expression Problem

Hi'

You can use

Valuelist('Level 0 YES','Level 0 NO')

See the Attached.

• ###### Re: Color by Expression Problem

Hello,

That did not work with what I was trying to accomplish. Thanks for trying though! I appreciate it!

• ###### Re: Color by Expression Problem

Hi Lauren Mills,