I have searched the forums and have not seen a question like this asked:
I am trying to count the number of times Average temperature moves by X %, up or down, over a specified time period, or on a rolling N day lookback.
For example: Over the past 20 days, how many times has Avg Temp moved (ABS, up or down) by 10%, 30%? Over the past 40 days? etc.
I am trying to work things using local min and max values, and countifs but cannot get much traction.
My data looks like the below. Any suggestions or links are appreciated.
I am trying to count the number of times Average temperature moves by X %, up or down, over a specified time period, or on a rolling N day lookback.
For example: Over the past 20 days, how many times has Avg Temp moved (ABS, up or down) by 10%, 30%? Over the past 40 days? etc.
I am trying to work things using local min and max values, and countifs but cannot get much traction.
My data looks like the below. Any suggestions or links are appreciated.