Overview
The Source Table:
The Result:
Macro combination:
- Insert the Jira Issues macro.
- Wrap the Jira Issues macro in the Table Transformer macro.
- Wrap the Table Transfromer macro in the Pivot Table macro.
Macro configuration:
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:
- Set the Cell value delimiter option: Comma (,)
