A chart date range limits the source records used by that chart. Check both boundary dates and the date field before interpreting a monthly comparison. An empty range control means all fixture dates here; it does not mean the latest month. The simulation uses created_date in ISO format and inclusive start and end dates. Live connector freshness, locale parsing and account time zones require separate production checks.
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.
Apply inclusive reporting dates before chart aggregation.