9 Replies Latest reply: Nov 27, 2015 10:28 AM by Jonathan Poole RSS

    combo chart color measures by expression

    Michal Samborski

      i'm using a combo chart to display two measures.  the two measure expressions are:

       

      sum(if([Availability woMW Severity]='Major',1,0))

      sum(if([Availability woMW Severity]='Minor',1,0))

       

      the resulting graph is:

      ss 2015-11-25 at 5.35.33 PM.jpg

      i need to assign a specific color to each line.  using the color by expression.  i tried a few iterations of the following, but it's not doing it for me.  any suggestions?

      if("Availability woMW Severity"='Major',RGB(255,0,0),if("Availability woMW Severity"='Minor',RGB(255,165,0)))

       

      is there a way to refer to a measure in an expression by using it's label, etc?  i.e. the two measures have labels "Major count" and "Minor count".  wondering if there's a function that allows something along the lines of if(MeasureLabel = "Major count",red,if(MeasureLabel = "Minor count",orange))