Sales summary
sales_summaryAggregate sales by month, category, brand, prefecture, or status for a date range, excluding cancelled orders unless grouping by status.
Instructions
Aggregate sales over a date range, grouped by month, product category, brand, customer prefecture or order status. Cancelled orders are excluded unless grouping by status.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | Inclusive end date. Defaults to the latest order. | |
| from | No | Inclusive start date. Defaults to the earliest order. | |
| group_by | No | month |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | Yes | ||
| from | Yes | ||
| rows | Yes | ||
| group_by | Yes | ||
| total_sales | Yes | ||
| total_orders | Yes |