Visualizing of Completed Story Points by Teams
The Source Table:
The Result:
Macro combination:
- Insert the Jira Issues macro.
- Add a table containing additional information for merging.
- Wrap the Table Filter macro and the table containing additional information in the Table Transformer macro.
- Wrap the Table Transformer macro in the Table Filter macro.
- Wrap the Table Transformer macro in the Pivot Table macro.
- Wrap the Pivot Table macro in the Chart from Table macro.
Macro configuration:
Table Filter: Filter Column | Status | Sprint |
---|---|---|
Filter Type | Dropdown | Dropdown |
Filter Values | Done | Reversed filter: '-empty-' |
Table Transformer:
Select the default Lookup tables preset and a column for matching the records.
Row Labels | Sprint |
---|---|
Column Labels | Team |
Calculated Column | Story points |
Operation Type | Sum |
Type | Column |
---|---|
Labels Column | Sprint |
Values Column | Sum of story points Team 1, Sum of story points Team 2, Sum of story points Team 3 |