schedule_breakdown
Count or average schedule metrics for NYC capital projects. Group data by agency, sponsor, borough, phase, or category to analyze project timelines.
Instructions
Counts/averages of schedule metrics by agency/sponsor/borough/phase/category.
agency scopes to one agency; agency_role ('auto'|'sponsor'|'managing') picks owner
vs builder lens (auto: sponsor, except DDC/DCAS/EDC -> managing). Category grouping
counts a PID once in EACH of its categories (non-additive). Report neutral, signed
variance.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group_by | Yes | ||
| metric | No | count | |
| statistic | No | count | |
| period | No | current | |
| agency | No | ||
| agency_role | No | auto |