Page tree

Overview


                                                           The Source Table:

                                                The Result:

Macro combination:

  1. Insert the Jira Issues macro.
  2. Wrap the Jira Issues macro in the Table Filter macro.
  3. Wrap the Table Filter macro in the Table Transformer macro.  (info)
  4. Add a table containing project milestones.  (info)
  5. Wrap the Table Transformer macro and the table containing milestones in the  Chart from Table  macro.

Macro configuration:

Table Filter:
Filter ColumnIssue typeSprint
Filter TypeVisualDropdown
Filter ValuesNew feature, ImprovementECS 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*
Chart from Table:
TypeGantt
Labels ColumnSprint, Key, Milestone
Values ColumnCreated, Due, Completion ratio, Date