how to switch geodata location when there are multiple locations with the same name
I'm trying to use the maps chart but the location is returning St. Petersburg, Russia instead of St. Petersburg, Florida. How do I switch it to St Petersburg in Florida? Can this be corrected in the chart or does it have to done in the script editor?
So I went into my master items for this dimension and changed the spelling from St Petersburg to Saint Petersburg like =IF(Capitalize(txtLocation)= 'St Petersburg', 'Saint Petersburg', txtLocation) ... how you spelled it out. and did custom scope, country 'US' and that fixed it!?! Thank you! 🙂