In SQL, using Analytical function would meet requirement. Something as shown below

value-lag(value) over (order by CollectionTime,metric)
[download]

My problem is with assigning the value for Hash key defined as Time in this case, and then Subtract it from latest value to the oldest value.

No idea how to do it in perl, some hint or suggestions would be very helpful to me.