Overview


                                                           The Source Table:


                                                The Result:


Macro combination:

  1. Insert the Jira Issues macro.
  2. Wrap the Jira Issues macro in the Table Filter macro.
  3. Wrap the Table Filter macro in the Pivot Table macro.


Macro configuration:

Table Filter:
Filter ColumnStatus
Filter TypeDropdown
Filter ValuesReversed filter 'Done'
Pivot Table:
Row LabelsAssignee
Column LabelsStatus
Calculated ColumnKey
Operation TypeCount, Literal

Additional parameters: