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.
Macro configuration:
Table Filter:
| Filter Column | Status |
|---|---|
| Filter Type | Dropdown |
| Filter Values | Reversed filter 'Done' |
Pivot Table:
| Row Labels | Assignee |
|---|---|
| Column Labels | Status |
| Calculated Column | Key |
| Operation Type | Count, Literal |
Additional parameters:
- Set the Literal value delimiter option: Bulleted list.
- Hide totals of the pivot table.
Find more use cases: