An Explore turns field selections into a grouped query. A dimension defines the groups; a measure calculates a value for each group. Select channel with total revenue to answer where sales came from. Adding order ID changes the grain to individual orders. Revenue and order count answer different questions, even when both columns contain numbers.
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.
Group order revenue by sales channel.