4 Replies Latest reply: Jan 17, 2013 6:15 AM by Ralph Graham RSS

    Adding timestamp when no value

      Hello,

       

      I have a database which has a timestamp field against every transaction and I want to display a bar chart that shows the number of transactions every minute, even when there is no data against a timestamp, e.g.

       

      ValueTimestamp
      232012-01-01 12:45:00
      452012-01-01 12:46:00
      112012-01-01 12:47:00
      62012-01-01 12:49:00
      92012-01-01 12:51:00

       

       

      In the above example I would want to the chart to show there is 23 against 12:45, 45 against 12:46, 11 against 12:47, 0 against 12:48, 6 against 12:49, 0 against 12:50 and 9 against 12:51.

       

      My question is essentially is there anyway to add timestamps where no data exists?

       

      Thanks,

       

      Ralph