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.
  4. Wrap the Pivot Table macro in the Chart from Table  macro.

Macro configuration:

Table Filter:
Filter ColumnStatus
Filter TypeDropdown
Filter ValuesDone
Pivot Table:
Row LabelsT
Column Labels-
Calculated ColumnOriginal Estimate, Time Spent
Operation TypeSum
Chart from Table:
TypeBar
Labels ColumnT
Values ColumnSum of Original Estimate, Sum of Time Spent