summarize
Calculate total expenses per category over a date range, with optional subcategory breakdown and category filter. Uses database aggregation for precise totals.
Instructions
Total spending over a date range, broken down by category.
Summing happens in Postgres over NUMERIC values, so the total is exact. Prefer this over listing every row and adding them up.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| category | No | Restrict to one category. When set, the breakdown is by subcategory instead of by category. | |
| end_date | No | Latest date to include, inclusive, YYYY-MM-DD. | |
| start_date | No | Earliest date to include, inclusive, YYYY-MM-DD. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||