Filter to show data in a time window around marked rows?

Hello, newbie here :slight_smile: 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.

Hi Silmarilly and welcome to the Community!

I’m not sure I understand your question. A sample dataset would help.