2 Replies Latest reply on Jul 24, 2018 7:37 AM by David Marquardt

    Bridging a line graph split by a dimension

    David Marquardt



      I've been trying to connect a line graph that I had identified with a dimension (which breaks the line graph) into two - estimates(blue) and projections (orange).

      I'd like to get some extension of the line (like the red dotted line below).




      Is there a way to do this? I've tried a calculated field using First and Last - no luck.


      IF LOOKUP(SUM([_estimate]),LAST())=0

      OR LOOKUP(SUM([_projection]),FIRST())=0

      THEN SUM([Value])



      Are there other ways to do this? Am I on the right track?