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
replace Borough in the Rows shelf with City , you will see the table shown in Figure 3-14 .
Notice anything wrong with the highlighted city name?
Search WWH ::




Custom Search