Cycle Time Analyzer (Flow Metrics)

Cycle Time Analyzer (Flow Metrics)

Overview

Compute and visualize the four core Kanban flow metrics -- lead time, cycle time, throughput, and work-in-progress -- from issue history data exported from Jira, Linear, GitHub Projects, or any tracker that records status transitions. The output is a dashboard suitable for sprint retrospectives, executive reporting, and bottleneck analysis, plus a Mermaid cumulative flow diagram that visualizes work accumulation over time.

Flow metrics are the most useful diagnostic for team and process health, far more so than velocity or story points. Daniel Vacanti's work (Actionable Agile Metrics for Predictability, 2015) shows that predictability and throughput are governed by Little's Law (Throughput = WIP / Cycle Time), and that the most reliable way to improve delivery is to lower WIP and stabilize cycle time -- not to estimate harder. This skill also reports aging WIP (in-flight work older than the team's 85th-percentile cycle time -- the items most at risk) and supports the shared --format schema (json, markdown, mermaid, confluence, notion, linear).

Core Capabilities

• Four flow metrics — lead time, cycle time (as a distribution, never an average), throughput, and WIP, tied together by Little's Law.
• Aging WIP — flags in-flight items older than the 85th-percentile cycle time as at-risk; the most actionable daily metric.
• Cumulative flow diagram — Mermaid CFD for retrospectives and exec reports.
• Per-type filtering & trends — bug/feature/spike breakdowns over rolling 6-8 week windows across all six output formats.

When to Use

• Sprint retrospective -- A team wants data-driven discussion of why some sprints feel slow.
• Bottleneck investigation -- Throughput has fallen and the team needs to identify the constraining step.
• Quarterly delivery review -- Leadership wants a real picture of delivery performance beyond story-point velocity.
• Predictability analysis -- Stakeholders want delivery forecasts grounded in actual cycle time distributions (use with Monte Carlo via scrum-master/).
• WIP-limit calibration -- A Kanban team is setting WIP limits and needs a baseline of current behavior.

When NOT to Use

• For story-point velocity tracking, use scrum-master/velocity_analyzer.py.
• For sprint capacity calculation, use scrum-master/sprint_capacity_calculator.py.
• For per-person performance evaluation -- flow metrics are team-level signals; using them to rank individuals destroys the team behavior they measure.

Clarify First

Before running the analysis, confirm these inputs. If any is unknown or vague, ASK — do not assume:

• Issue history with status transitions — per-item timestamps for when work started and finished (every metric is derived from these; missing transitions invalidate the numbers)
• Workflow states that count as "in progress" vs "done" — your board's actual status names (defines where cycle time starts/stops, which changes every result)
• Analysis window — the rolling period (e.g. last 6-8 weeks) and any type filter (scopes throughput trend and which in-flight items are flagged as aging WIP)

Stop rule: ask only the 2-3 that most change the output. If the user says "just draft it," proceed and list your assumptions at the top of the artifact.

Quick Start