Min Value Check Examples

The situation: Every order in the orders table must carry a total above zero. Rows with 0 come from a checkout bug that saves the order before the cart is priced, and they distort revenue reporting.

Check configuration

Payload

{
    "description": "Order total must be greater than zero.",
    "rule": "minValue",
    "fields": ["o_totalprice"],
    "container_id": 145,
    "coverage": 1,
    "filter": null,
    "properties": {"value": 0},
    "tags": ["orders", "range"],
    "additional_metadata": {"jira": "DATA-8101"},
    "anomaly_message_field": null,
    "template_id": null,
    "status": "Active",
    "owner_id": 7,
    "default_anomaly_assignee_id": 12
}

Sample Data

What gets flagged

Order 2 holds exactly 0, and the floor is exclusive, so it is flagged. Order 4 is NULL and passes without firing an anomaly. Coverage is 100%, so the failing row is reported as a Record Anomaly.

Flowchart

graph TD
    A["No filter, evaluate all rows"] --> B["Read o_totalprice"]
    B --> C{"Is value NULL?"}
    C -->|Yes| D["Row passes"]
    C -->|No| E{"Is o_totalprice > 0?"}
    E -->|Yes| D
    E -->|No| F["Flag row.<br/>Record Anomaly per failing row."]

Equivalent SQL

-- Rows the Min Value check would flag.
SELECT o.*
FROM orders o
WHERE o.o_totalprice IS NOT NULL
  AND o.o_totalprice <= 0;

The situation: Support sessions marked as billable must last more than 5 minutes. Non-billable sessions can be any length and are out of scope for this check.

Check configuration

Payload

{
    "description": "Billable sessions must last more than 5 minutes.",
    "rule": "minValue",
    "fields": ["duration_minutes"],
    "container_id": 512,
    "coverage": 1,
    "filter": "billable = true",
    "properties": {"value": 5},
    "tags": ["support", "billing"],
    "additional_metadata": {"jira": "DATA-8144"},
    "anomaly_message_field": null,
    "template_id": null,
    "status": "Active",
    "owner_id": 7,
    "default_anomaly_assignee_id": 29
}

Sample Data (filtered to billable = true)

Why the filter matters

The filter runs before the comparison, so non-billable sessions are never tested against the minimum. Only billable rows are evaluated.

What gets flagged

S-02 lasted exactly 5 minutes, and the floor is exclusive, so it does not qualify as billable. Coverage is 100%, so the failure is reported as a Record Anomaly, and the message ends with the filter that scoped the evaluation.

Flowchart

graph TD
    A["Apply filter: billable = true"] --> B["Read duration_minutes"]
    B --> C{"Is duration_minutes > 5?"}
    C -->|Yes| D["Row passes"]
    C -->|No| E["Flag row.<br/>Anomaly message ends with<br/>[filter: billable = true]"]

Equivalent SQL

-- Rows the check would flag among billable sessions.
SELECT s.*
FROM support_sessions s
WHERE s.billable = true
  AND s.duration_minutes IS NOT NULL
  AND s.duration_minutes <= 5;

The situation: A pressure sensor cannot physically report a value at or below zero. A faulty unit is producing a few such readings while it is being replaced, so the check tolerates up to 0.5% failures.

Check configuration

Payload

{
    "description": "Pressure readings must be greater than zero.",
    "rule": "minValue",
    "fields": ["pressure_kpa"],
    "container_id": 733,
    "coverage": 0.995,
    "filter": null,
    "properties": {"value": 0},
    "tags": ["telemetry", "plausibility"],
    "additional_metadata": {"jira": "DATA-8188"},
    "anomaly_message_field": null,
    "template_id": null,
    "status": "Active",
    "owner_id": 7,
    "default_anomaly_assignee_id": 52
}

Sample Data

What gets flagged

Readings R-02 and R-03 come from the same faulty unit: one reports zero, the other a negative value, and both fail the exclusive floor. R-04 is NULL, so it passes without firing an anomaly but still counts in the scanned total. Only 50% of the rows pass, which is below the 99.5% coverage threshold, so the check reports a single Shape Anomaly for the dataset with a sample of the offending rows. Coverage below 100% does not produce Record Anomalies.

Flowchart

graph TD
    A["No filter, evaluate all rows"] --> B["Read pressure_kpa"]
    B --> C{"Is value NULL?"}
    C -->|Yes| D["Row passes"]
    C -->|No| E{"Is pressure_kpa > 0?"}
    E -->|Yes| D
    E -->|No| F["Flag row.<br/>Passing rate falls below the 99.5%<br/>coverage, so one Shape Anomaly is reported."]

Equivalent SQL

-- Rows the check would flag.
SELECT r.*
FROM sensor_readings r
WHERE r.pressure_kpa IS NOT NULL
  AND r.pressure_kpa <= 0;