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
