Filtering based on visit duration (GPS Points)

[gradstudent0998]

Hello Everyone,

I am trying to filter mobile data based on the duration of a visit sequence such that visitations that are less than 4 mins and more than 240 minutes are removed from the original dataset.

I have Mobile location data with Hashed Device ID (unique ID), long, lat, date, and time. In a single day, the unique ID is duplicated many times / Day, reflecting a ping for location. Also, the IDs are random each day, which means that similar IDs on different days are not the same mobile phone.   So far I've been able to calculate the time difference and cumulative time between pings on the same day using the multirow formula (by choosing grouping ID and Date).

Here's an example of what I'm looking for. The red being the rows that need to be removed

However, I need to filter to eliminate movement sequences that are less than x minutes and more than y hours. Would truly appreciate any help on how to proceed with this.

Thank You

[gabrielvilella · Accepted solution]

You can calculate the total duration then use a join as filter.

[gradstudent0998]

That works perfectly thank you so much!!