Time Series with offset subtraction from Measurements

Hello all, I am trying to do some data visualization with a Time Series.

This is an example of the Measurements I have (“hot”, “cold”):

So what I’d like to do:
Define a time-window, for instance 1h. Take all the Measurements of “hot” from [“now” to “now-1h”] and subtract from all those values the Measurement value at “now-1h”. So I’d like to shift the Measurements in this 1h window down by an offset equal to the value where the 1h-time-window starts. Something like that:

Is something like that possible?
Thank you so much for your help!