Hello, newbie here I’m working on dataset which has a column for each analysis type against a timestamp at a 2-hourly interval. The main analysis type (Analysis1) is updated every 2-3 days, so it shows the previous value against the timestamps until a new value is uploaded. The other analysis types are uploaded every 2 hours.
I need to look at the data for all analysis types in a window around the updated Analysis1 result (4-hour to 24-hour window). I’ve marked the rows as per below but now I’m not sure what to do next.
To mark the rows where new values are updated I did the following (I followed the advice given on different topic):
- shifted the Analysis1 column up by one row (new column PrevAnalysis1),
- calculated a new column to compare PrevAnalysis1 with Analysis1, if the values are different it is marked 1, otherwise 0
Appreciate any advice you may have, thank you.