Adding timestamp when no value

[#1]

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.

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?

Thanks,

Ralph

[nirav_bhimani]

Hi,

You want data like Value Time

                          eg. 23   12:45:00

then try this in script,

right(TimeStamp,8) as TimePeriod

Regards,

Nirav Bhimani

[#3]

Hello,

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.

Thanks,

Ralph 

[nirav_bhimani]

Hi,

I am not getting what you want, Can you share a demo file.

Regards,

Nirav Bhimani

[#5]

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.

Thanks,

Ralph