Looker Studio uses a data source with dimensions and aggregated metrics. It is a separate product from Looker and does not require editing LookML for this task. Choose orders as the source, region as the dimension and SUM revenue as the metric. Counting revenue values would count populated cells. The workspace uses fixture tables instead of live connectors and keeps source credentials as a configuration exercise.
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.
Build a chart directly from a data source.