Setting up dashboard for tracking multiple locations
I'm working on building a Dashboard that tracks performance of 8 specific locations in 8 different states. The problem I'm running into is that a few of the locations are commonly named cities and appear in multiple states throughout the US. What would be the appropriate way to set up a filter to only pull in the specific city I need, while ignoring the cities with the same name in a different state. It looks like one of the filters i can apply is "City ID" where can I find a list of the city ID's?