5 Replies Latest reply: Feb 3, 2015 10:29 AM by jorge gardeazabal RSS

    Accumulation in line chart - Change line colour from a certain accumulated point onwards

      Dear all,

       

      I am having a problem with the design of a line chart.

       

      I have it done so that we see on the x-axis the clients ranked by the amount of sales, and on the y-axis we see the relative accumulated sales with respect to the total amount of sales.

       

      This is the look of my graph right now.

      However, I would like to have it done so that from the point in which line crosses 25 % onwards, its color changes from blue to red. Do you know how can I do this?

       

      I have tried with this formula in the colour option of the expression, but I do not get the results that I am looking for:

       

      if((RangeSum(Above(rank(sum({$<INVOICEYEAR={'2014'}>}(WEIGHT/1000))),0,RowNo())))/(sum({$<INVOICEYEAR={'2014'}>}(WEIGHT/1000)))<='0,25',rgb(0,0,0),rgb(255,0,0))

       

      Can anybody help me please?

       

      Thank you very much!!

       

      Jorge