Database Reference
In-Depth Information
To add the
Rank
field to the bar chart, simply drag it to the left of
Borough & Com-
munityDistrict (Combined)
on the Rows shelf. After removing the row dividers, we have
the colored, sorted, and now ranked bar chart shown in
Figure 4-11
.
Figure 4-11. Adding the Rank field to the bar chart
Alternatively, since the launch of Version 8.1, users can create a similar
Rank
field by mak-
ing use of the new Rank Table Calculation. To do so, drag another instance of
Recycle to
Refuse Ratio
to the columns shelf, click in the down arrow of the new pill, and change it to
Discrete
, and then click the down arrow again and select
Quick Table Calculation
and then
Rank
. Finally, click the down arrow once more and select
Compute using
, then choose
Bor-
ough CommunityDistrict (combined)
. (This calcuated field also lets you handle ties in differ-
ent ways.)