Hi, i have timestamped gps records in a database of several devices.
Those records are filtered in order to established a relationship with an area.
How can i retrieve time spent on a specific area ?
Thanks
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+44- Influencer
- 3429 replies
Use a statistics calculator to find the min and max time for each area, then a date time calculator to work out the difference between min and max
thanks @egomm for your answer
i made a test with your proposal but it can't detect when a device go on other area and come back on the first area. i explain with an example :
idtimedeviceplace
12019-01-01 10:001PLACE 1
22019-01-01 10:01
1PLACE 1
32019-01-01 10:02
1PLACE 2
42019-01-01 10:03
1PLACE 2
52019-01-01 10:04
1PLACE 1
62019-01-01 10:05
1
PLACE 172019-01-01 10:06
1PLACE 3
i would like to have 4 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:01
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 1 from 2019-01-01 10:04 to 2019-01-01 10:05
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
but with your proposal i ve got only 3 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:05
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
+44- Influencer
- 3429 replies
thanks @egomm for your answer
i made a test with your proposal but it can't detect when a device go on other area and come back on the first area. i explain with an example :
idtimedeviceplace
12019-01-01 10:001PLACE 1
22019-01-01 10:01
1PLACE 1
32019-01-01 10:02
1PLACE 2
42019-01-01 10:03
1PLACE 2
52019-01-01 10:04
1PLACE 1
62019-01-01 10:05
1
PLACE 172019-01-01 10:06
1PLACE 3
i would like to have 4 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:01
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 1 from 2019-01-01 10:04 to 2019-01-01 10:05
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
but with your proposal i ve got only 3 results
in PLACE 1 from 2019-01-01 10:00 to 2019-01-01 10:05
in PLACE 2 form 2019-01-01 10:02 to 2019-01-01 10:03
in PLACE 3 from 2019-01-01 to 10:06 2019-01-01 10:06
In that case, you need to create groupings to use in the statistics calculator. Adjacent attribute handling in the attribute creator will allow you to assign a group, e.g.
time_on_area.fmwt