Field Health Metrics

When applied to a table or view, Field Health Monitors automatically begin tracking and reporting on anomalies across the metrics listed below. These monitors are ideal for important tables within your organization where null or non-distinct field values would result in a data quality issue. By tracking these statistics over time, we’re able to intelligently notify you when anomalies occur. Note that you need to configure Field Health monitoring on tables and views.

The following list includes all metrics automatically tracked with Field Monitors. While trend reporting is available for all metrics, some metrics are not yet configured to notify you of anomalies. To enable alerting on an excluded metric please contact us using the Intercom bot or at [email protected]

Metric

Definition

Supported field types

Analytics

Anomaly detection

% Null

Percentage of rows that have a NULL value

All

Yes

Yes

% Unique

Number of distinct values divided by total number of values

All

Yes

Yes

% Zero

Percentage of rows that have the value 0

Numeric

Yes

Yes

% Negative

Percentage of rows that have a negative value

Numeric

Yes

Yes

Min

Minimum across all rows

Numeric

Yes

Coming Soon

p20

20th percentile

Numeric

Yes

Yes

p40

40th percentile

Numeric

Yes

Yes

p60

60th percentile

Numeric

Yes

Yes

p80

80th percentile

Numeric

Yes

Yes

Mean

Mean value across all rows

Numeric

Yes

Yes

Std

Standard deviation of values

Numeric

Yes

Coming soon

Max

Maximum across all rows

Numeric

Yes

Coming soon

Min length

Minimum count of characters over non-null values

Strings

Yes

Coming soon

Mean length

Mean count of characters over non-null values

Strings

Yes

Coming soon

Std length

Standard deviation of the count over non-null values

Strings

Yes

Coming soon

Max length

Maximum count of characters over non-null values

Strings

Yes

Coming soon

% Whitespace only

Percentage of rows where the string contains only whitespace characters, e.g. \n, \t, space

Strings

Yes

Yes

% Integer

Percentage of rows where the string represents a valid integer number

Strings

Yes

Yes

% "Null"/"None"

Percentage of rows where the string is equal to 'null', 'None' or similar tokens

Strings

Yes

Yes

% Float

Percentage of rows where the string represents a valid floating point number

Strings

Yes

Yes

% UUID

Percentage of rows where the string represents a valid UUID, e.g. '256bc0d3-dedd-4c3f-b6f8-aced33238bc6'

Strings

Yes

Yes


Did this page help you?