Your dashboard is green and the number is wrong: the SQL checks I schedule next to every metric

Most broken dashboards don't look broken. The chart renders, the numbers are plausible, the pipeline says success. Then someone in finance asks why last month's revenue changed after the fact, and you...