3 Replies Latest reply: May 25, 2017 4:13 AM by Michele De Nardi RSS

    issue in applying customized color to bargraph through color expression

    Supriya R

      Hi,

       

      i am trying to apply customized color throught color expression

       

      Dimenion1:match(question_id,'Q1','Q2')

      Diemnsion 2 : if((Match(answer_text,'Strongly Agree','Excellent')),'Strongly Agree',if(Match(answer_text,'Agree','Above Average'),'Agree'))

      Expression: count(distinct{<question_id={'Q1','Q2'}>} lender_offer_id)/count(distinct {<question_id={'Q1','Q2'}>} total lender_offer_id)

       

      color expression:

      If(question_id = 'Q1', if(answer_text = 'Strongly Agree', lightblue(),LightMagenta()),

      If(question_id = 'Q2', if(answer_text = 'Strongly Agree',  LightGreen(),LightRed())))

       

      Here everything looks good to me. But i am not able to chage color of Strongly Agree option of Q1. It remains whole color with megenta.

      Captureimg.PNG

      Please help me on this.