Aggregating Tasks when One Task is Included in Multiple Sprints |
The Source Table:
The Result:
Table Transformer:
Use the following SQL query:
SELECT *, 'sprint'->split("SCRUM Sprint ")->reverse()->0 AS 'sprint' FROM T1 WHERE T1.'Status' = "Done" AND 'sprint'->split("SCRUM Sprint ")->length > 2 UNION ALL CORRESPONDING SELECT *, "To Do" AS 'Status', 'sprint'->split("SCRUM Sprint ")->slice(1,-1)->toString() AS 'sprint' FROM T1 WHERE T1.'Status' = "Done" AND 'sprint'->split("SCRUM Sprint ")->length > 2 UNION ALL CORRESPONDING SELECT *, 'sprint'->split("SCRUM Sprint ")->toString() AS 'sprint' FROM T1 WHERE T1.'Status' <> "Done" OR 'sprint'->split("SCRUM Sprint ")->length < 3 |
Row Labels | sprint |
---|---|
Column Labels | Status |
Calculated Column | story points |
Operation Type | Sum |
Additional parameter: