Hello,
I'm trying to select rows where duration is greater than 1 sec. When I try to do this rows that show a duration of 1 sec are getting selected as well. What am I missing? Sample data table attached if needed.
Details of what I'm trying to accomplish
We have data that is recorded every second. I was trying to check if there were any gaps or periods that were not recorded.
Currently trying to complete this check for an entire year, over 25 million rows. Final table would have a start date/time, end date/time column and a column that says the duration of time that there was no data for.
Steps taken
- Started with my column of Date&Time.
- Created a second column with formula Lag(:Date&Time, -1) and called it EndDate&Time
- Created a third column that took difference from EndDate&Time and Date&Time column and named it TimeDiff
- Attempted to select where TimeDiff is greater than 0:00:01
-Row that have a value displayed of 0:00:01 are also being selected.