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: