Populate the shelves of the visual:
stname
field onto the X shelf.tot_pop
field onto the Y shelf.tot_pop
field, chose the Aggregates menu, and change the aggregate from Sum to Average.tot_pop
field, chose the Order menu, and select Ascending.stname
field, and then select Enter/Edit Expression menu.In the Enter/Edit Expression modal window,
<<dim:[stname]>>
.Change the name of the visual to Average population by <<dim>>.
Note that in this case, to have a nice title in your application, you must add the <<dim>>
parameter to the title of the visual; it is used by the filters you are defining next.