A cached query result can be correct for its original source snapshot and stale after a new load. Diagnose freshness by checking load completion, cache policy and the query result timestamp. Increasing a dashboard refresh frequency does not necessarily invalidate a warehouse or query cache. This browser runs queries over a deterministic fixture and cannot measure production latency, query cost or cache-hit performance.
Use the field picker and the generated result together. The warehouse contains repeated customer keys, orders with several items and missing values. Those rows make a plausible-looking total insufficient evidence. Run the requested definition, inspect its grain, and use the feedback to locate the mismatch. Every dataset here is fictional.
Separate a cached result from a changed source.