Calculating Velocity |
The Source Table:
The Result:
Filter Column | Sprint |
---|---|
Filter Type | Dropdown |
Filter Values | Reversed filter '-empty-' |
Row Labels | Sprint |
---|---|
Column Labels | Status |
Calculated Column | Story points |
Operation Type | Sum |
See also a page: Aggregating Tasks when One Task is Included in Multiple Sprints |
Table Transformer:
Use the following SQL query:
SELECT 'sprint', MIN(TT1.'Sum of story points') AS 'Story Points Committed', MIN(TT1.'Sum of story points Done') AS 'Story Points Completed', AVG(TT2.'Sum of story points Done') AS 'Velocity' FROM T1 AS TT1 JOIN T1 AS TT2 on TT1.'sprint' >= TT2.'sprint' WHERE TT1.'sprint'<>"Total" GROUP BY TT1.'sprint' ORDER BY TT1.'sprint' |
Additional parameters:
Set the Decimal places option: 1.
Type | Column |
---|---|
Labels Column | Sprint |
Values Column | Story Points Committed, Story Points Completed |
|
For the first column of the table:
Table Transformer:
Use the following SQL query:
SELECT TOP 1 'Velocity' FROM T1 ORDER BY 'sprint' DESC |
For the second column of the table:
Table Filter:Filter Column | Status |
---|---|
Filter Type | Dropdown |
Filter Values | Reversed filter 'Done' |
Row Labels | - |
---|---|
Column Labels | - |
Calculated Column | Story points |
Operation Type | Sum |
|
For the whole table:
Row Labels | - |
---|---|
Column Labels | - |
Calculated Column | Velocity, Story points unresolved |
Operation Type | Sum |
Table Transformer:
Use the following SQL query:
SELECT ('Sum of Story points unresolved' / 'Sum of Velocity') AS 'Number of sprints to complete unresolved story points' FROM T* |
Additional parameters:
Set the Decimal places option: 1.
|