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

    Bridging a line graph split by a dimension

    David Marquardt

      Hello,

       

      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])

      END

       

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

       

      David