16 Replies Latest reply: Nov 30, 2016 2:35 AM by Lech Miszkiewicz RSS

    Color Expression on stacked bar chart based on measure

    Bashar Khalid

      Hi, I have a stacked bar chart that has one dimension and two measures. the dimension is 'Customer' and the measures are 'SuccessCDR' and 'FailCDR', on the stacked bar chart, I want the 'SuccessCDR' to show as lightgreen() instead of blue and 'FailCDR' to show as lightred() instead of red.

       

      Untitled.jpg

       

      Every example i have found is checking a value like

       

      if(Type='Discussion',blue(),if(Type='Replies',Green(),Red()))

       

      Except in my case there is no field value, I just want that measure to show up with a different color expression.

      Something like this

       

      if('SuccessCDR',green(),if('FailCDR',Red()))


      How do i do this?