The Source Table:
The Result:
Macro combination:
- Insert the Jira Issues macro.
- Wrap the Jira Issues macro in the Table Filter macro.
- Wrap the Table Filter macro in the Pivot Table macro.
- Wrap the Pivot Table macro in the Chart from Table macro.
Macro configuration:
Table Filter:
| Filter Column | Status |
|---|---|
| Filter Type | Dropdown |
| Filter Values | Done |
Pivot Table:
| Row Labels | T |
|---|---|
| Column Labels | - |
| Calculated Column | Original Estimate, Time Spent |
| Operation Type | Sum |
Chart from Table:
| Type | Bar |
|---|---|
| Labels Column | T |
| Values Column | Sum of Original Estimate, Sum of Time Spent |
Find more use cases: