Versions Compared
compared with
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
Excerpt | ||
---|---|---|
| ||
Visualizing of Completed Story Points by Teams |
The Source Table:
The Result:
Image Added
Image Added
Macro combination:
- Insert the Jira Issues macro.
- Wrap the Jira Issues macro in the Table Filter 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 Pivot Table macro.
- Wrap the Pivot Table macro in the Chart from Table macro.
Handy Tip | ||
---|---|---|
| ||
You can include any table from your Confluence instance using the Table Excerpt and Table Excerpt Include macros. |
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.
Handy Tip | ||
---|---|---|
| ||
If the columns for matching have different labels in multiple tables, use the query from the example. |
Pivot Table:
Row Labels | Sprint |
---|---|
Column Labels | Team |
Calculated Column | Story points |
Operation Type | Sum |
Chart from Table:
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 |
Handy Carousel |
---|