Comparison of Graphs of Open and Resolved Tasks |
Step 1. Configure Table1:
Step 2. Configure Table2:
Step 3. Wrap Table1 and Table2 in the Chart from Table macro.
Step 1. Configure Table1:
Row Labels | Created |
---|---|
Column Labels | - |
Calculated Column | Summary |
Operation Type | Count |
Use the following SQL query:
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' |
Filter Column | Resolved |
---|---|
Filter Type | Dropdown |
Filter Values | Reversed filter '-empty-' |
Row Labels | Resolved |
---|---|
Column Labels | - |
Calculated Column | Summary |
Operation Type | Count |
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' |
Type | Time Area |
---|---|
Dates Column | Created, Resolved |
Values Column | Count |