Overview
Content Tools
Apps
Step 1. Configure Table1:
Step 2. Configure Table2:
Step 3. Wrap Table1 and Table2 in the Chart from Table macro.
Step 1. Configure Table1:
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 |
Use the following SQL query:
SELECT 'Resolved', (SELECT SUM(T2.'story points') FROM T2) - 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'
Filter Column | Sprint |
---|---|
Filter Type | Dropdown |
Filter Values | ECS Sprint 3 |
Row Labels | - |
---|---|
Column Labels | - |
Calculated Column | Story points |
Operation Type | Sum |
Type | Time Line |
---|---|
Dates Column | Resolved |
Values Column | Ideal, Actual |