Skip to main content
Below is a complete profile insights reference table
Profile InsightDescriptionQuality DimensionProfile Type
Null CountTotal number of records where the field contains a NULL value, indicating completely missing data. High null counts may signal data collection failures, unpopulated optional fields, or ETL pipeline gaps.CompletenessEssential
Empty CountCount of records containing an empty string ('') rather than NULL. Empty strings are non-null but carry no meaningful content — common in unvalidated form inputs and text fields.CompletenessEssential
Non-Empty CountCount of records containing a meaningful, non-null, non-empty value. The primary completeness indicator. Calculated as Total Records - Null Count - Empty Count.CompletenessEssential
Space CountCount of records where the field contains only whitespace characters (spaces, tabs, newlines). Space-only values are neither null nor empty yet contain no useful information — a hidden completeness gap often missed by basic null checks.CompletenessEssential
Distinct CountThe number of unique values present in a field, excluding nulls. For a primary key field, distinct count must equal total record count. Helps identify cardinality and validate field uniqueness expectations.Uniqueness / IntegrityEssential
Repeating CountThe count of values that appear more than once. Calculated as Total Count - Distinct Count. High repeating counts in key fields (e.g., customer IDs, order numbers) indicate duplication and referential integrity violations.Uniqueness / IntegrityEssential
Digits CountCount of records containing one or more numeric digit characters (0–9). Used to validate that identifiers, phone numbers, or postal codes contain the expected digit composition.Validity / FormatEssential
Special Character CountCount of records containing non-alphanumeric characters such as @, #, $, %, &, *. Elevated counts in fields expected to contain only letters or numbers indicate data entry errors, encoding issues, or injection risks.Validity / FormatEssential
Alphabet CountCount of records containing purely alphabetic characters (A–Z, a–z). Validates that text-only fields such as first and last names do not contain unexpected numeric or special characters.Validity / FormatEssential
Alpha Numeric CountCount of records containing both alphabetic and numeric characters. Essential for validating mixed-format fields like product codes, license plates, and reference numbers.Validity / FormatEssential
Leading SpaceCount of records where the field value begins with one or more space characters. Leading spaces are invisible in most UIs but silently break exact-match comparisons and join operations. Example: ' John' ≠ 'John'.Consistency / FormatEssential
Trailing SpaceCount of records where the field value ends with one or more space characters. Trailing spaces are a common artifact in fixed-length fields exported from legacy systems and cause lookup failures.Consistency / FormatEssential
Outer SpaceCombined count of records with either leading or trailing spaces. An aggregated signal for edge whitespace issues across the entire field, covering both leading and trailing space cases in a single metric.Consistency / FormatEssential
Inner SpaceCount of records containing multiple consecutive internal space characters. Example: 'John Smith' (two spaces) vs 'John Smith' (one space). Typically indicates data merging errors or unvalidated free-text input.Consistency / FormatAdvanced
Whitespace CountTotal count of all whitespace characters (spaces, tabs, carriage returns, line feeds) across all field values. A high ratio relative to total character count may indicate padded, poorly formatted, or embedded-formatting values from source systems.Consistency / FormatAdvanced
Zero CountCount of records where a numeric field contains exactly 0. Distinguishing zeros from nulls is business-critical — a zero account balance differs fundamentally from an unknown balance. Elevated zero counts may indicate default value substitution or rounding errors.Accuracy / ValidityEssential
Positive CountCount of records where a numeric field contains a value greater than zero. Used alongside Negative Count and Zero Count to validate sign distribution expectations for financial, operational, or scientific data.Accuracy / ValidityEssential
Negative CountCount of records where a numeric field contains a value less than zero. Unexpected negatives in fields like age, quantity, or price indicate data entry errors or sign convention mismatches between source systems.Accuracy / ValidityEssential