Calculating Velocity |
Filter Column | Sprint |
---|---|
Filter Type | Dropdown |
Filter Values | Reversed filter '-empty-' |
Row Labels | Sprint |
---|---|
Column Labels | Status |
Calculated Column | Story points |
Operation Type | Sum |
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' |
Type | Column |
---|---|
Labels Column | Sprint |
Values Column | Story Points Committed, Story Points Completed |
Use the following SQL query:
SELECT TOP 1 'Velocity' FROM T1 ORDER BY 'sprint' DESC |
Filter Column | Status |
---|---|
Filter Type | Dropdown |
Filter Values | Reversed filter 'Done' |
Row Labels | - |
---|---|
Column Labels | - |
Calculated Column | Story points |
Operation Type | Sum |
Row Labels | - |
---|---|
Column Labels | - |
Calculated Column | Velocity, Story points unresolved |
Operation Type | Sum |
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* |