Metrics

The metrics visualization provides a statistical overview of the data in a table, which can help identify trends or irregularities. You can display statistics for one or more fields in a table. The type of statistical information that appears depends on the data type of the field. Table 1 itemizes the available information. Figure 1 displays a metrics visualization for three fields:

If one or more filters are applied to a table, the statistics are calculated based on the records that remain in the table after the filter has been applied.

Figure 1. Metrics for numeric, datetime, and character fields

 

Table 1. Statistical information provided by the metrics visualization

Data type of field

Information item

Description

Numeric

Highest

The five highest values in the field

Lowest

The five lowest 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

Std. Deviation

The standard deviation from the average value

Count

The total number of values in the field, including zero values

Positives

The number of positive values in the field

Negatives

The number of negative values in the field

Zeros

The number of zero values in the field

Datetime

Most Recent

The five most recent dates in the field

Earliest

The five earliest dates in the field

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

Std. Deviation (in Days)

The standard deviation, measured in days, from the average date

Count

The total number of values in the field, including blank dates

Blanks

The number of blank 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

Related concepts
About visualizations
Related tasks
Viewing metrics


(C) 2015 ACL Services Ltd. All Rights Reserved.