value-lag(value) over (order by CollectionTime,metric)