RedHub AIRedHub AI
Tool Gate · How it works

How the roll-up gate works

How the Enum & Status-Value Drift gate works

This tool grades the values a field actually holds against the set you declared allowed. It reads 5 fields and rolls them into one verdict — the worst, never the average — then a gate that can only make it worse.

The 5 fields

01invoice.statefix first25,560 rows - partially_paid is out of setSET BROKEN
02lead.source_channel10,900 rows - 8% on a Referral variant, gate firedSET BROKEN
03ticket.status76,088 rows - 88 rows (0%) on an In Progress variantVARIANTS PRESENT
04order.status76,088 rows - 88 rows (0%) on an In Progress variant, twin of ticket.statusVARIANTS PRESENT
05subscription.plan32,300 rows - every value in the declared setSET CLOSED
SETS HOLD
every field's values stay inside the declared set
DRIFT FOUND
worst field carries variants only, under the row-share gate
SETS BROKEN
any field has a true out-of-set value, or its variant rows clear the row-share gate
Row-share gate · worsen-only

A field reads SET BROKEN if any value truly falls outside the declared set - like invoice.state's partially_paid - or if variant rows alone clear 5% of the field's rows, which promotes a spelling variant into a second value your systems write regularly, even with zero out-of-set rows.

SETS BROKEN

Why: Two fields hold VARIANTS PRESENT with a harmless spelling drift on well under 1% of rows. But invoice.state carries a genuinely new value - partially_paid - that was never declared, and lead.source_channel's Referral variant alone clears the 5% row-share gate. The sweep reads the worst field, not the average, so it's SETS BROKEN. 2 of 5 fields broken · worst-not-average · 1% of 220,936 rows off-set.

Fix firstinvoice.state - partially_paid is a genuinely new value, not a spelling variant; add it to the declared set or route those rows before trusting anything downstream.

No single field is the crisis — the clustering is. The roll-up takes the worst, the gate escalates when trouble compounds, and it names the one thing to fix first. Grades the values you paste in. Not legal or compliance advice, and it connects to nothing on its own.