SELECT 'Created', SUM (TT2.'Count') AS 'Count'
FROM T1 AS TT1
JOIN T1 AS TT2 on TT1.'Created' >= TT2.'Created'
GROUP BY TT1.'Created'
ORDER BY TT1.'Created'
Step 2. Configure Table2:
Table Filter:
Filter Column
Resolved
Filter Type
Dropdown
Filter Values
Reversed filter '-empty-'
Pivot Table:
Row Labels
Resolved
Column Labels
-
Calculated Column
Summary
Operation Type
Count
Additional parameters:
Set the Date period aggregation option: Week.
Table Transformer:
Use the following SQL query:
SELECT 'Resolved', SUM (TT2.'Count') AS 'Count'
FROM T1 AS TT1
JOIN T1 AS TT2 on TT1.'Resolved' >= TT2.'Resolved'
GROUP BY TT1.'Resolved'
ORDER BY TT1.'Resolved'