Open (or create) a visual based on US County Population dataset.
The specifics for a sample visual follow:
stname
field, aliased as state
, and ctyname
field, aliased as country
tot_pop
field, then change the expression to sum([tot_pop]) as 'population'
tot_male
field and change the expression to sum([tot_male]) as 'males'
, and add tot_female
field and change the expression to sum([tot_female]) as 'females'
year
field, change expression to year=5
, and aggregrp
field, change expression to aggregrp=0
Click Refresh Visual.