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

    Color by Expression Problem

    Lauren Mills

      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!