A time dimension group creates several fields from one timestamp or date expression. Select the month timeframe to aggregate all orders in the same calendar month. Grouping by the raw date leaves separate daily rows. This fixture uses ISO dates without time-of-day values, so the workspace does not model warehouse time-zone conversion. Keep that boundary in mind before applying the pattern to production timestamps.
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.
Create reusable date and month grains.