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
Solved! Go to Solution.
That works perfectly thank you so much!!