Show Statistics

Description

Displays statistics about a column. Statistics will show you, among others:

1. • If your table has enough rows for you to work with

   • If there are nulls or blanks

   • The maximum, minimum, and average length of the values of the column

   • The number of unique values in the column

   • The sum of all values of a numeric column

STEPS

1. Right-click on a column whose statistics you want to view.

2. Select Statistics > Show Statistics. The Statistics Panel displays.

To close to hide the Statistics Panel, select Hide Statistics .

example

In this example, we've displayed the statistics for the column Customer:

 

A quick review shows that:

1. • No records have null values

   • There are 64 rows in the table

   • There are 21 unique Zip Codes n the table