Building a Gantt Chart |
You can include any table from your Confluence instance using the Table Excerpt and Table Excerpt Include macros or use any default and custom columns of the Jira Issues macro. |
We insert the Table Transformer macro in order to calculate the Completion ratio based on the Jira Issues macro columns. If you have any other column containing percentage values or don't need to visualize progress bars in the chart, you can skip this step. |
Filter Column | Issue type | Sprint |
---|---|---|
Filter Type | Visual | Dropdown |
Filter Values | New feature, Improvement | ECS Sprint 2, ECS Sprint 3, ECS Sprint 4 |
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* |
Type | Gantt |
---|---|
Labels Column | Sprint, Key, Milestone |
Values Column | Created, Due, Completion ratio, Date |