2 Replies Latest reply on Aug 31, 2016 9:12 PM by Ivan Young

    How do I visualize constant values over time durations?

    Jared Warren

      Suppose that I have a table like this:

       

      Start DateEnd DateValue
      1/1/20156/1/201523
      2/1/20155/1/201545
      3/1/20158/1/201520
      2/15/20159/1/201550
      9/2/201510/1/201549

       

      Note that durations described by the Start Date and End Date columns can (and do) overlap with each other.

       

      I would like to visualize this as a series of lines with "Value" on the y-axis and date on the x-axis.  I would like a line to start at value 23, date 1/1/2015 and end at 6/1/2015.  Then, repeat that for each row with a new line.

       

      (In real life there's another column that I'll use to turn the lines different colors...but that part is easy).

       

      Any tips or suggestions?

       

      Thanks!

      Jared