Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Mybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:



Excerpt
hiddentrue

Visualizing of Completed Story Points by Teams


The Source Table:

The Result:



Macro combination:

  1. Insert the Jira Issues macro.
  2. Add a table containing additional information for merging. (info)
  3. Wrap the Table Filter macro and the table containing additional information in the Table Transformer macro.
  4. Wrap the Table Transformer macro in the Table Filter macro.
  5. Wrap the Table Transformer macro in the Pivot Table macro.
  6. Wrap the Pivot Table macro in the Chart from Table macro.
Handy Tip
id3565172410870956

You can include any table from your Confluence instance using the Table Excerpt and Table Excerpt Include macros.


Macro configuration:

Table Filter:

Filter ColumnStatusSprint
Filter TypeDropdownDropdown
Filter ValuesDoneReversed filter: '-empty-'

Table Transformer:

Select the default Lookup tables preset and a column for matching the records. (info)

Handy Tip
id16714769186053924

If the columns for matching have different labels in multiple tables, use the query from the example.

Pivot Table:

Row LabelsSprint
Column LabelsTeam
Calculated ColumnStory points
Operation TypeSum

Chart from Table:

TypeColumn
Labels ColumnSprint
Values ColumnSum of story points Team 1, Sum of story points Team 2, Sum of story points Team 3



Handy Carousel


Excerpt Include
Using Table Filter and Charts in Combination with the Jira Issues Macro
Using Table Filter and Charts in Combination with the Jira Issues Macro
nopaneltrue