I'm trying to do a visualization, of what I percieve to be quite a basic scenario, but I can't get it to work!
Each document have: clientId (string), timestamp, geohash.
I want to show a map of the LATEST location for each clientId, meaning:
Group by unique ClientId, get the max timestamp for each, show only these documents on the map.
Unfortunately, it looks like the coordinate map visualization is missing sub aggregations, so I'm not able to shape my data and aggregate it before showing it, like I can in other visualizations! Or can I?
Thanks in advance,