Statistics

Statistics provide an overview of the data in a table that you can use to identify trends or irregularities.

Data configuration settings

When you configure statistics, you select one or more table fields to use. If any filters are applied to the selected fields, the calculations reflect these filters.

Calculation terms per data type

Data type of field Term Definition
Numeric Count The total number of records in the current table view
Positives The number of positive values in the field, displayed in green
Negatives The number of negative values in the field, displayed in red
Zeros The number of zero values in the field
Total The total of the values in the field
Average The average of the values in the field
Range The difference between the highest and lowest values in the field
Standard Deviation The standard deviation from the average value
Highest The five highest values in the field
Lowest The five lowest values in the field
Datetime Range (in days) The number of days between the most recent date and the earliest date in the field
Standard deviation (in days) The standard deviation, measured in days, from the average date
Count The number of non-blank dates in the field
Blanks The number of blank dates in the field
Most Recent The five most recent dates in the field
Earliest The five earliest dates in the field

Character

Unique Values

The number of unique values in the field. One or more blank values count as 1 unique value

Blanks The number of blank values in the field

Example

Statistics for numeric, datetime, and character fields