Earlier this week I downloaded the dataset
"USA_Census_Populated_Places_USA_Census_Populated_Places" downloaded from data.World.

I used this dataset to prepare this week's input for me.

My goal was to click on the states on the map of the USA to create interactivity for a pie chart and a bar chart. I also wanted to define a parameter that would allow the user to choose between population, density, and housingunits.

First, I created a map of the U.S. showing each state, excluding Hawaii and Alaska, for the sake of clarity.

How to exclude:

In the next step, I created the parameter that allows the user to choose between population, density and houseunits.

For this parameter we still need a calculating field in order to change the measures later by clicking on this parameter. The Purple part of the Syntax stands for the Parameter following by the 'KEYWORDS'.

Now we need set that shows us the five top cities in each state while clicking on the state on the map. Make sure you bring this set on the filter.

For this set we define another calculated field to get our top 5 cities (City Set) in a bar chart by clicking on the respective state.

Now I created another set with the states and drag that to the filter an add it to a context filter by right clicking on the filter 'add to context'.

As follows we setup our action 'set' filter.

And finaly a normal action filter.

Now users can toggle between population, density, and housing units on the dashboard, and interact selected states on the map with the pie chart and bar graph using action filters.