trend
Group time series data by day, week, month, quarter, or year to display counts, averages, and totals.
Instructions
Analyze time series data: group rows by time period and show counts, averages, and totals.
Args: database: Name of the database from config. table: Name of the table. date_column: Name of the date/timestamp column to group by. value_column: Optional numeric column to aggregate (avg, sum). If omitted, shows counts only. period: Grouping period: day, week, month, quarter, year. Default: month.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | ||
| table | Yes | ||
| date_column | Yes | ||
| value_column | No | ||
| period | No | month |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |