Wrap the Table Filter macro and the table containing milestones in the Table Transformer macro.
Wrap the Table Transformer macro and the table in the Chart from Table macro.
Macro configuration:
Table Filter:
Filter Column
Issue type
Sprint
Filter Type
Visual
Dropdown
Filter Values
New feature, Improvement
ECS Sprint 2, ECS Sprint 3, ECS Sprint 4
Table Transformer:
Use the following SQL query:
SELECT *,
CASE WHEN 'Status' = "Done"
THEN "100%"
WHEN 'Status' = "To Do"
THEN "0%"
ELSE (100 - ('Remaining Estimate' / 'Time Spent' * 100) + "%")
END AS 'Completion Ratio'
FROM T*