KPI discrepancy: 163 billion versus expected 819 billion raises concerns

TL;DR A metrics engine had two query paths — a SQL push-down for big datasets, an in-memory aggregator for small ones. They drifted. The push-down path bound a metric parameter but never added it to the WHERE. With several metric series in one dataset, every query summed across all of them. A KPI th