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.
Value
Timestamp
23
2012-01-01 12:45:00
45
2012-01-01 12:46:00
11
2012-01-01 12:47:00
6
2012-01-01 12:49:00
9
2012-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?
What I actually require is that where there are no transactions against a particular time (e.g. 12:50:00 in the above example) that a timestamp is created (either in the script or an expression) and that a value of 0 is attached to this timestamp.
I've attached a test document. As you can see on the chart it has 5 different values spread across 7 minutes (from 23:50 to 23:57), what I want to show is for the minutes that have no data the timestamp but with no data. In other words I want to identify times when there is no output as the chart would be misleading by not showing the particular time.
