Building a Gantt Chart

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. 
4. Add a table containing project milestones. 
5. Wrap the Table Transformer macro and the table containing milestones in the  Chart from Table  macro.

Macro configuration:

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*