timepiece_aggregate
Aggregate time-in-status statistics (average, sum, median, standard deviation) across Jira issues matching a JQL query. Returns a markdown table or JSON.
Instructions
Aggregate time-in-status statistics across multiple Jira issues.
Computes average, median, sum, or standard deviation of time spent in each status across all issues matching the JQL query.
Args: params (AggregateInput): Validated input containing: - aggregation_type (str): 'average', 'sum', 'median', or 'standardDeviation' - jql (str): JQL query to select issues - columns_by (str): Column grouping (default: statusDuration) - calendar (Optional[str]): Timepiece calendar ID or name - day_length (str): 'businessDays' or 'calendarDays' (default: businessDays) - view_format (str): 'days', 'hours', 'minutes', 'seconds' (default: days) - statuses (Optional[str]): Comma-separated status IDs to filter - dbs_metrics (Optional[str]): JSON for duration-between-statuses metrics - response_format (str): 'markdown' or 'json' (default: markdown)
Returns: str: Aggregated time-in-status statistics as a Markdown table or JSON.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |