7 Replies Latest reply: May 27, 2017 8:49 PM by Pranahitha Nellutla RSS

    color by expression using a dimension not showing in the chart?

    Pranahitha Nellutla

      Hi is there a way I can write an expression using a dimension iam not showing in the chart?

      For Example :

       

       

      col1(dimension1)col2(dimension2)measure
      njkabc2.3
      njkuio5.6
      rbjoip7.8
      xyznji9
      xyzkji8.9
      xyzlpo7.6

       

      col1 and col 2 are related data but iam only using col2(dimension1)) in my bar chart. Iam sorting descending on measure

      But I want to color the exprssion by col1(dimension1)

       

      expression:

      if(dimension1='xyz' then green, ...n so on....)

       

      colnp1.jpg

       

      thanks

      Prana