trend_query
Get time-bucketed trend data for any table to generate monthly or weekly trend charts. Specify date field, grouping, and optional filters.
Instructions
Get time-bucketed trend data for a table (useful for monthly/weekly trend charts)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | No | Optional encoded query filter | |
| table | Yes | Table name (e.g., "incident") | |
| periods | No | Number of months to look back (default: 6) | |
| group_by | Yes | Secondary grouping field (e.g., "priority", "state") | |
| date_field | Yes | Date field to bucket by (e.g., "opened_at", "sys_created_on") |