Available Metrics Types

The count of rows with a null value in the column e.g.

Sample dataset:

Null

Null

23

Metric value: 2

The total number of rows in a table e.g.

Sample dataset:

78

6

89

23

45

Metric value: 5

The count of distinct elements in the column. This metric should be used when you expect a fixed number of value options e.g.

Sample dataset:

Cat

Dog

Cat

Metric value: 2

The count of rows with a duplicate value in the column (excluding the unique value). eg

Sample dataset:

Apple

Apple

Pear

Pear

Banana

Pear

Metric value: 3

Apple has 1 duplicate, Pear has 2 duplicates, result is 3

The minimum value of the column e.g.

Sample dataset:

78

6

89

23

45

Metric value: 6

The maximum value of the column e.g.

Sample dataset:

78

6

89

23

45

Metric value: 89

The median of the column. The median is computed as the 50th percentile, and will only return a value that is in the dataset e.g.

Sample dataset:

78

6

89

23

45

Metric value: 45

The statistical skew of the column. The skew is used to determine how evenly the values are distributed about the mean e.g.

Sample dataset:

78

6

89

23

45

Metric value: 0.0303028253

The variance of a column from its sample mean. This should be used to calculate the variance when the data represents a sample taken from a larger data set e.g.

Sample dataset:

78

6

89

23

45

Metric value: 1244.7

The variance of a column from its population mean. This should be used to calculate the variance when the data represents the entire data set e.g.

Sample dataset:

78

6

89

23

45

Metric value: 995.76

The geometric mean of a column e.g.

Sample dataset:

78

6

89

23

45

Metric value: 33.644590126644

Date

Timestamp

The difference in hours of the maximum value of the column and the metric’s collection time e.g.

Sample dataset in UTC (Metric collected at 2022-12-07 03:48:00 UTC):

2022-12-06 05:24:26 
2022-12-07 01:33:36
2022-12-07 00:33:44

Metric Value: 2.07333