Hours and revenue grouped by up to three levels
mite_reportGenerate aggregated time tracking reports grouped by up to three dimensions to summarize hours, revenue, and share of hours for any period.
Instructions
Aggregated report from mite: hours, revenue and share of hours, grouped by 1 to 3 of customer, project, service, user, day, week, month, year for a period, on the mite server so whole years work. For the fixed project-by-month view use mite_report_projects_by_month, for billable share use mite_report_billable_ratio, for budgets use mite_report_budget. Returns rows with hours, revenue in currency units (null without rates) and share of hours in percent, plus a total. 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. | |
| group_by | Yes | 1 to 3 distinct values from: customer, project, service, user, day, week, month, year, e.g. ["customer", "month"]. Required; the order sets the column order. | |
| 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. |