Building a Burnup Chart |
The Source Table:
The Result:
Step 1. Configure Table1:
Step 2. Configure Table2:
Step 3. Wrap Table1 and Table2 in the Chart from Table macro.
Step 1. Configure Table1:
Table Filter:Filter Column | Status | Sprint |
---|---|---|
Filter Type | Dropdown | Dropdown |
Filter Values | Done | ECS Sprint 3 |
Row Labels | Resolved |
---|---|
Column Labels | - |
Calculated Column | Story points |
Operation Type | Sum |
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' |
Instead of using Table Transformer, since the 7.4.0 version of the app, you can enable the Cumulative count option in the Pivot Table macro. |
|
Step 2. Configure Table2:
Filter Column | Sprint |
---|---|
Filter Type | Dropdown |
Filter Values | ECS Sprint 3 |
Row Labels | - |
---|---|
Column Labels | - |
Calculated Column | Story points |
Operation Type | Sum |
Step 3. Wrap Table1 and Table2 in the Chart from Table macro.
Type | Time Line |
---|---|
Dates Column | Resolved |
Values Column | Ideal, Actual |