10 Replies Latest reply on Nov 21, 2013 3:25 PM by Joshua Milligan

    How can I display a previous value when the current value doesn't exist?

    Varayut Lerdkanlayanawat

      Hi,

       

      I am creating a financial dashboard in the form of line plot. The problem occurs when the date isn't continuos. .

      For example,

       

      DateBalance
      2010-07-1410
      2010-07-1812

       

      If a client wants to see the balance of his account on 2010-07-15, it won't show anything. Actually, It should display 10. Therefore, the line graph should remain 10 until '2010-07-18', then trends to 12.

       

      Is there a way to achieve this?

       

      Thanks,

      Varayut