Database Reference
In-Depth Information
Figure 3-13. Using Number of Records to show counts
Notice how the
Number of Records
pill is a summation. To understand how
Number of
Records
behaves, imagine a field in the data set of 1s. Summing this field for Brooklyn, for
example, shows that there are 11,887 times that “Brooklyn” appears in the
Borough
field.
This can be a very helpful way to find anomalies or errors in the data set. For example, if you
Notice anything wrong with the highlighted city name?