Currently, I’m using a map visualization(points on map) to track my devices. I have multiple devices that send data (latitude, longitude, and other parameters) at regular intervals (every few seconds/minutes).
Using parameters, I can select a specific device and, based on a time range, view where that device has been.
However, when I try to display the locations of all devices together, the map becomes cluttered (as shown below). I would like to display only the latest location of each device—just one point per device.
Additionally, for a single device, is there a way to connect the points based on time, or visualize the path to understand how the device moved from one location to another?
Also, are there any available documents or guides on how to display geofences or trackers (location service) maps in Amazon QuickSight along with the location points ( FYI: data points are from Amazon Athena dataset )?
This is a very interesting use case! To handle the visual logic to only show the latest location per device will have to be done through a calculated field. I do not know what fields you have within your dataset, but the logic of the calculated field could look something like this:
and then you will have to apply a filter on your visual to only show values that equal ‘Yes’. Ideally speaking this should only show the latest points within your visual.
For your question about visualizing movement paths, Unfortunately, the Points on Map visual doesn’t have a way to draw lines between points. Your best bet is the Layer Map and it lets you upload GeoJSON shape layers. If you pre-generate ‘LineString’ features for each device’s path (ordered by timestamp), you can overlay those routes right on the map. If you want something quicker and don’t need actual lines, try putting a sequential color gradient on the timestamp in the color well. I do not believe it will connect the dots, but I think the light-to-dark progression may give a decent sense of direction.
Lastly for your geofences or tracker question, there is no direct integration between Location Service geofences and QuickSight yet, but the Layer Map works here too. Just export your geofence collection as GeoJSON polygons, upload it as a shape layer, and you’ll see your boundaries alongside your device points. Upon researching this topic, I did find a blog post that talks about combining Athena data with Location Service on a map that might be useful.
