Hello!
I have been trying to create a filter within looker studio to only see cities within a specific county (in California for example) for a geo map that shows active users per city.
I have been trying to blend data, but I am new to looker studio so I am not sure how to create a filter that would include specific cities if someone can help! I don’t want to have to do a filter for every single city!
Good question!
If your data doesn’t include county level information, you’ll have to add that in yourself. Like you mentioned, a blend would be the way to put this together with your existing data.
If you don’t have access to the database itself, an easy way to create your own data source is by creating a google sheet. You can make a sheet with one column for county and one column for city, then list all of the county-city pairs.
Finally, blend your data source with your new google sheet, joining on city. That should allow you to create a county filter that will filter for each city in that county!