7 Replies Latest reply: Sep 11, 2014 3:34 PM by Massimo Grossi RSS

    Chart Line Style

      Hello,

       

      I created a Line chart with:

      • Dimensions:
        • Month
        • Product & ' - ' & Metric_Type (Calculated Dimension)
      • Expression:
        • (Sum({<$(vMAT)>}Values) - the variable is to show the last 12 month

      I have two Metric_Type (SO and SI). I want the the Line Style to be different for the Metric_Types, so I tried this scripts in the Line Style of the expression:

      • =if(Metric_Type='SI','<S3>')
      • =if(mid(Product & ' - ' & Metric_Type,1,2) ='SI','<S3>')

       

      but didn't work...

       

      Suggestions?

       

      Thanks in advance,

       

      Francisco