Forum Discussion

Maureen's avatar
Maureen
Helper III
6 years ago
Solved

Using Address Location

What is the best way to display a city on a bubble map when the best location information that you have is city and state?    I have designated my city column as "city" and state as "state" for data category.  I have also tried building a new column with city, state and designating it as address location which the bubble map does not seem to recognize - it maps nothing with this new field.  If I put both city and state in the location fields, it will map the state but not the city.  If I build a hierarchy with city within state, it will correctly display the state but if I drill-down to city, the city may not land in the state (for example, St. Petersburg, FL shows up in Russia instead of Florida).  How can I make the bubble map see the city and the state together . . .