Skip to end of metadata
Go to start of metadata

Jira Issues Macro & Table Filter & Pivot Table & Chart from Table

  1. Add the Jira Issues macro and configure its parameters.
  2. Insert the Table filter macro and place the Jira Issues macro within the macro.
  3. Add the filters and configure the filtration parameters.
  4. Insert the Pivot Table macro.
  5. Place the Table filter macro with the table inside the Pivot Table macro.
  6. Configure the parameters of the pivot table.
  7. Insert the Chart from Table macro.
  8. Place the Pivot Table macro inside the Chart from Table macro.
  9. Configure the parameters of the chart.
  10. Save the page.
  11. Change the filtration criteria and the pivot table parameters. The chart will be automatically updated.
  12. Change the chart parameters if needed.

The Table Filter, Pivot Table, Chart from Table macros work only with the rows currently displayed on a page. They can't influence or make changes (such as collecting not displaying data) to the built-in (Jira Issues, Task Report, Page Properties Report) and third-party macros.

To filter more values within one page you need to increase the number of rows per page to display.

Combine the macros in the new Confluence Cloud editor with the help of the Table Toolbox macro

Before you start

  1. Before you can use the Jira Issues macro, your Confluence and Jira application must be connected via Application Links. People viewing the page will see the publicly accessible issues from the Jira site. If your Jira site has restricted viewing (that is, people need permission to view issues) then they will need to authenticate before seeing the restricted issues.
  2. The Table Filter and Charts app processes the issues displayed on a page. If you want to filter, aggregate and visualize all the issues, you need to set the maximal number of issues to display in the Jira Issues macro settings.
  3. In all the use cases below, we use JQL: 'project = name' and apply filtration with the Table Filter macro. You can filter issues using JQL.
  4. When you work with date values and worklogs you need to be sure that the date format and worklog settings are correct.