How to zoom into specific city/set of ZIPs on filled map via dropdown filter?

Question & Answer
, , , , , ,
1

Hello,

I have a dataset that has market_name, which typically corresponds to a city in a state in the USA, i.e. Atlanta. For each market, there are corresponding zip_code for which I am mapping some value for. So a row in this dataset would look something like: market_name = Atlanta, zip_code = 30304, value = 56.

With this dataset, I am able to successfully create a filled map that showcases how corresponding values within each ZIP differ. At the top of the dashboard, I have a filter which allows a user to select the market_name of interest. However, I am unable to figure out how to dynamically adjust the map such that it zooms into that ZIPs corresponding to the specific market_name/city the user chooses.

Could someone advise on how to do this? Thanks!

2

Hi @apqs and welcome to the QuickSight community!
What if you tried building an ifelse statement to handle the filtering of your visual?
It would probably look something like this:

ifelse(
${market_name_parameter} = 'Atlanta', '30304', 
${market_name_parameter} = 'New York', '07020', 
....,
NULL)

Then, set this up as a filter for your map visual.
It may be a bit tedious as you’ll need to setup for every combination that you have available.

Let me know if you have any additional questions

3

hi @Brett, thanks so much for your response–I think I understand what you are saying. You are saying that for each market_name, choose a central ZIP such that the filled map visualizations in the dashboard will zoom into that specific area.

Here’s what I’ve done so far:

So at the top of my dashboard, I have a control that is a dropdown selection of all the markets available to view, which is a variable called market_name across all datasets used in this dashboard.

I then created a calculated field for my filled map visualizations within the dashboard called market_name_zoom wherein I wrote the following:

ifelse(
{market_name} = 'Atlanta', '30304', 
{market_name} = 'Austin', '78702', 
NULL)

However, this calculated field isn’t picking up on the market_name from the dropdown menu at the top and isn’t adjusting the zoom.

When I modify the code to be ${market_name} = 'Atlanta', '30304', ... as per your suggestion, it said ‘Errors found’ so I removed the “$” and it saved without errors, but it isn’t actually doing anything.

Any ideas on how to troubleshoot? Thanks!

4

Hi @apqs,
Sorry for the confusion. So I’m thinking you were getting an error because ${…} refers to the usage of a parameter. Is your Market Name control linked up to a parameter or is it a filter control? Make sure to set it up as a parameter and then use that parameter name in the ifelse statement.

ifelse(
${Market_name_parameter} = …

Using your normal market name field in the ifelse won’t work so let me know if adding the parameter instead solves the issue.

The zoom feature can be a little fickle at times and sometimes if you’re trying to link a field that’s not geospatial (like I’m assuming the market name field may not be) you’ll run in to issues with it responding to the ‘zoom’ request.