Page History

Macro combination (the chart is based on two transformed pivot tables):

Step 1. Configure Table1:

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 Pivot Table macro.
4. Wrap the Pivot Table macro in the Table Transformer macro.

Step 2. Configure Table2:

1. Insert the Jira Issues macro (or use one Jira issues macro for both tables with the help of the Table Excerpt and Table Excerpt Include macros).
2. Wrap the Jira Issues macro in the Table Filter macro.
3. Wrap the Table Filter macro in the Pivot Table macro.
4. Place the Pivot Table macro in a cell of the a manually created table containing start and end dates of a sprint.

Step 3. Wrap Table1 and Table2 in the Chart from Table macro.

Macro configuration:

Step 1. Configure Table1:

Table Filter:

Pivot Table:

Table Transformer:

Use the following SQL query:

SELECT 'Resolved', SUM (TT2.'Sum of story points') AS 'Actual'
FROM T1 AS TT1
JOIN T1 AS TT2 on TT1.'Resolved' >= TT2.'Resolved'
GROUP BY TT1.'Resolved'
ORDER BY TT1.'Resolved'

Step 2. Configure Table2:

Table Filter:

Pivot Table:

Step 3. Wrap Table1 and Table2 in the Chart from Table macro.

Chart from Table: