Metrics for numeric, datetime, and character fields
Statistics provide an overview of the data in a table that you can use to identify trends or irregularities.
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.
| 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 | Average | The average date in the field |
| 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 |