I just figured out how to get metabase to split a cell and reliably pull GPS data into two custom columns (labeled Longitude and Latitude). When I go to visualize, I select map and here's where I hit the issue. When I go to tell metabase what column is longitude or latitude, it won't give me those columns as options. I verified that the custom columns I made are numerical (they have the "#" sign indicating so when viewing through the filter section).
The long/lat are in a 9 digit format (i.e. 37.161084 and -86.523160 and each in their separate column). What could be the issue and how can I work past it? I've tried looking through the forum here and I wasn't able to deduce anything. Any help is always appreciated!