Hours and revenue per project and month
mite_report_projects_by_monthGenerates monthly hours and revenue totals per project for a selected period, enabling review of annual project performance without listing individual time entries.
Instructions
Aggregated report from mite: hours and revenue per project and month for a period, grouped on the mite server so whole years work without reading single entries. For other groupings or totals use mite_report; for single entries use mite_list_time_entries. Returns rows of month (YYYY-MM), project, hours and revenue in currency units plus a total; revenue is null without rates. Read-only, no paging, default period is this year.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | End of the period: a date as YYYY-MM-DD (e.g. 2026-03-31) or a keyword (today, yesterday, this_week, last_week, this_month, last_month, this_year, last_year). Default: today when only from is a date; without from the period is just this date. | |
| from | No | Start of the period: a date as YYYY-MM-DD (e.g. 2026-01-01) or a keyword (today, yesterday, this_week, last_week, this_month, last_month, this_year, last_year). A keyword alone selects that whole period and ignores the end of it; a date alone runs up to today. Default: this_year (when from and to are both omitted). | |
| user_id | No | Only these users: list of mite user ids, e.g. [7]. Needs an API key that may see other users. Default: all users the key may see. | |
| billable | No | true = only billable entries, false = only non-billable entries. Default: both. | |
| project_id | No | Only these projects: list of mite project ids, e.g. [789]. Default: all projects. | |
| service_id | No | Only these services: list of mite service ids, e.g. [42]. Default: all services. | |
| customer_id | No | Only these customers: list of mite customer ids, e.g. [123, 456]. Default: all customers. |