Database Reference
In-Depth Information
Figure 4-9. Bar chart of community districts
Now we can quickly tell which are the top four or five districts, and which are the bottom
four or five. Using the colored bars, we also can see some patterns, like that the districts with
the lowest ratio are all in the Bronx (blue), and most of the top ten are in Manhattan (green).
But if I asked you to pick out the tenth or the fifteenth districts, you'd have to count down
from the top, right? Not the easiest task to perform. How can we add rank to this list to easily
pick out the order from 1 to 59?
Two Ways of Adding Rank
Let's create a
Rank
field. To do so, right-click anywhere in the Dimensions or Measures pan-
el on the left and select
Create a Calculated Field
once again. This time, name the field
Rank
