I’m having trouble with lat and long fields. I have set the datatypes to latitude and longitude in the edit data section, however, when I try to build a dashboard using these fields I get the following error message:
Hello @tom1 , welcome to the Quicksight community!
To double check, when you changed the data type in the dataset, were you sure to save and publish your changes before moving back to the analysis?
I would recommend making a table of your lat and long fields to see how they render in your analysis to help see what might be causing that error.
Hi,
When you import the data, QuickSight should automatically detect it is a latitude and longitude, the fact that you had to specify them might point to a formatting error.
To compare to your dataset, you can use the rows from a mock .csv I use to test map coordinates and works fine.
trip_id,start_latitude,start_longitude,end_latitude,end_longitude,pickup_datetime,dropoff_datetime,fare_amount,passenger_count,payment_type
1,-7.9594608,112.637271,-18.3591857,-44.6254642,2023-02-10T08:39:01Z,2023-01-28T03:38:15Z,583.09,8,cash
2,47.4098736,32.4412263,5.3453369,95.8353837,2023-04-16T15:39:30Z,2022-09-28T02:20:56Z,368.76,3,credit card
3,49.6046109,14.2774242,49.7058855,6.3726286,2023-06-06T08:47:44Z,2022-11-04T10:14:32Z,86.16,1,cash
4,56.6203091,43.4086631,34.38528,36.03111,2022-12-14T08:15:46Z,2022-11-06T04:42:46Z,549.46,5,credit card
5,30.8783105,120.0907688,-7.229,106.9856,2022-11-27T21:06:19Z,2023-03-06T12:20:23Z,364.8,3,credit card
6,-37.0920575,-73.1545822,49.4023766,20.3031211,2023-06-05T13:49:39Z,2022-10-16T04:32:51Z,376.89,9,debit card
7,30.754014,113.820729,34.883333,69.716667,2023-04-21T23:39:45Z,2023-08-01T07:47:09Z,196.3,2,credit card
8,35.202503,102.521807,45.8903748,-77.2672051,2023-05-07T03:23:02Z,2023-01-11T13:44:23Z,25.52,9,cash
9,1.0931431,36.7018311,-7.340531,112.7077638,2022-09-08T18:48:27Z,2023-05-20T07:30:06Z,225.79,8,cash
10,46.9962539,28.8716267,48.819324,2.394771,2022-09-14T00:25:33Z,2023-04-05T04:17:15Z,760.67,2,cash
Hope this helps troubleshooting your issue!
Kind regards,
Andres.