Forum Discussion
Aggregating identical trailing rows
Consider the following table Index Timestamp Text Text Change Duration 1 01.01.2021 12:00:00 Text B true 90 2 01.01.2021 13:30:00 Text B false 30 3 01.01.202...
Does that mean you don't care about the timestamp for index 2 for example?
As for the final outcome you are correct. In other words, any timestamp in rows with 'Text change' = false is irrelevant. Only difference in time between rows with 'Text change' = true is relevant.
E.g. difference in time between index 1 and 3, 3 and 4, 4 and 7 etc.