Hey @duncan !! Thank you very much for getting back for this!
I understand and will proceed with a ticket as you advise.
For the record the issue seems to be with the coords themselves.
I got (of course) longitude and latitude coords with values that get divided by 1000 for some unknown reason.
So for the time being I’ve worked around it by creating calculated fields within the data prep UI to get them working properly. The fact they get divided by 1000 results in showing a mini world map (if you zoom in enough) near the -0.01 , 0.01 coords (south west Africa). Zooming out of course results in a clustered single point on the world map.
Last but not least this seems to happen when involving the SPICE engine after joining an excel file to an RDS or Aurora table/dataset.
zoomed in version near the 0.0 coords as below:
any help here (if maybe this is something from my end I have no idea about) would really be appreciated!
edit: It seems im not the only one Points on map - weird behaviour - Question & Answer - Amazon QuickSight Community