2 Replies Latest reply: Jan 22, 2015 9:59 AM by Melissa van Kluyve RSS

    Dynamic line chart background colours

      Hi gurus,


      I have a line chart of historic data, volume plotted against 'Historic Week Start Date'. I want my line colour to change based on historic Fiscal Year.


      I have currently achieved this by hard coding in the following in the Background Colour section of my expression:








      This achieves the intended result:



      However, to account for the possibility of the data being loaded in for more / different fiscal years, I would like to make this expression dynamic.


      I have another field, 'HistoricalFYRow' which is a row count, which could potentially be used in the expression (as was finding it difficult to do max / min on the fiscal year field (FY11, FY12...).


      Suggestions of how to modify this formula, perhaps with a variable?