A derived table exposes a SQL query as a view. The regional table has one row per region, so its order_count column is already aggregated. Sum that column to recover total orders; counting regional rows would count regions. SQL derived tables here run locally over one fixture table with SELECT, WHERE, aggregates and GROUP BY. Warehouse persistence and scheduled rebuilds remain outside the browser simulation.
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.
Aggregate to a declared grain before exploring it.