get_revenue_report
Retrieve total revenue grouped by product category, year, or month, excluding cancelled orders. Optionally filter by year to narrow results.
Instructions
Get total revenue grouped by product category, by year, or by month. Cancelled orders are excluded. year optionally restricts results to one year (also applies to 'month' grouping). Use this instead of writing the orders→order_items→products join yourself.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | No | ||
| group_by | Yes |