A persistent derived table is built in the warehouse and reused until its persistence rule requires a rebuild. The rule must follow source freshness and the business reporting tolerance. A browser preview can validate query logic but cannot prove production rebuild timing or database permissions. Use a datagroup when related content should share a refresh boundary, and verify the configured SQL trigger in the real environment.
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.
Plan refresh behavior without claiming a browser scheduler.