| Warning |
|---|
This version of the app's documentation is outdated. Please find the information you're looking for here:Visualizing of Completed Story Points by Teams |
| Excerpt | ||
|---|---|---|
| ||
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.
| 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 |
|---|
|
| Excerpt Include | ||||||
|---|---|---|---|---|---|---|
|