Flow Metrics Report (Scaled Agile Framework, SAFe)
This SAFe (Scaled Agile Framework) report script is a comprehensive analysis and visualization tool designed to provide insights into sprint progress, cumulative flow, cycle time, and system throughput.
Purpose
This report aims to
Provide a clear overview of sprint progress and team velocity.
Highlight bottlenecks or inefficiencies in the workflow by analyzing cycle time and cumulative flow.
Enable actionable insights through drill-down capabilities and detailed status history tracking.
Use Cases
Agile Coaches: To assess team performance and identify areas for process improvement.
Scrum Masters: For tracking sprint health and ensuring alignment with sprint goals.
Product Owners: To monitor issue progress and delivery timelines.
Report Functionality
Report Overview:
Chart contains following visualisations:
Cumulative Flow Diagram (CFD): Displays issue statuses over time, with an overlay of velocity data.
Cycle Time Breakdown: Visualizes how much time issues spend in each status over time.
System Throughput: Illustrates output rates for each status and the overall system velocity.
Charts include interactive elements like tooltips, zoom, and sprint mark areas.
Cumulative Flow Diagram
Cycle Time Breakdown chart
System Throughput chart
User guide
1. Sprint Picker
Use the Sprint Picker to define the scope of your report:
Project Selection:
Select the relevant project (e.g., Mobile Dev (MOBL)).
Board Selection:
Choose the Scrum board associated with the project (e.g., MOBL Cowboys).
Sprints Selection:
Pick one or more sprints for analysis (e.g., MOBL Sprint 1, MOBL Sprint 2).
2. Select Issue Types
Filter the report to include only the issue types you are interested in:
Examples: Bug, Story.
Use this to focus on specific work items relevant to your analysis.
3. Statuses Order
Define the workflow statuses and their order for the report:
Examples: To Do, Architecture Review, In Progress, Testing, Accepted, Done.
The statuses will appear in this sequence in visualizations like the Cumulative Flow Diagram and Cycle Time Breakdown.
4. First Status
Set the First Status to specify the initial status of issues included in the report:
Example: To Do.
This is the starting point of the workflow.
5. Last Status
Choose the Last Status to indicate the final status that marks issue completion:
Example: Done.
This is typically the end of the workflow.
6. Wait Statuses
Define any statuses that represent waiting or inactive periods in the workflow:
Examples: To Do, Architecture Review.
Note: Currently is no in use in the report
7. Velocity Aggregation
Choose how velocity data should be aggregated:
Options include Daily, Weekly, Monthly, or Per Sprint.
Example: Daily aggregation will calculate how much work is completed each day.
8. Cycle Time Aggregation
Define the granularity for cycle time analysis:
Options include Daily, Weekly, Monthly, or Per Sprint.
Example: Daily aggregation will break down the time spent in each status day by day.
Report import
Report is not available in public repository yet, but you can import it manually by opening the file below and following this instruction Report Builder: "How to export and import a Scripted Report" guide | Report Import