Subtracting data from a certain timestamp.

[#1]

I have three columns timestamp, feed, click_count. I need to subtract the click_count from the click_count five minutes earlier

Timestamp Feed click_count

7/15/2010 00:05 BraveNet 1

7/15/.2010 00:10 Bravenet 4

I need a way to create another column to calculate the difference between the click at 00:05 and the click at 00:10 for the answer t be 3 clicks.

I am pulling this data from a qvw.

Thanks LIZ

[fernandotoledo]

Look for previous() function in a " load resident;" in the help, there is a good example there. You can also use the peek() function.

[#3]

Thanks, that seem to do the trick.