3 Replies Latest reply: Sep 20, 2016 7:01 AM by Arjun Arjun RSS

    Hiding "null values" in line chart with accumulation

    Jonathan Stokes

      Hi there!

       

      I have a "progress towards target" line chart (screenshot attached) which accumulates with the following function:

      RangeSum(Above(Sum([Indirect beneficiaries]),0,rowno()))

       

      Although the "target" line should continue to 2020, I'd like the cumulative "indirect beneficiaries" line to stop at the most recently reported quarter.


      Does anyone know how this could be achieved? Although this change may seem trivial, I know that users will not look at this for long and I want it to be very clear where we have data and where we don't yet.

       

      Thanks!

      Jonathan