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 ColumnTSprint
Filter TypeVisualDropdown
Filter ValuesImprovement, New FeatureReversed filter: '-empty-'
Pivot Table:
Row LabelsSprint
Column LabelsStatus
Calculated ColumnStory points
Operation TypeSum
Chart from Table:
TypeColumn
Labels ColumnSprint
Values ColumnSum of story points Done, Sum of story points In Progress, Sum of story points To Do
Additional parameters: