Old Street Solutions Ltd. © 2018-2020

  • Tom Harris

How to Create Jira Reports and Charts in Confluence

Updated: Mar 2

Share & Customise Jira Charts in Confluence for Reporting to the rest of your team:

  1. Add Jira Issue or Filter Macros to Confluence Pages

  2. Use the Jira report blueprint to create a change log or Status report

  3. Use the Jira chart macro to display data as a chart, including pie charts, created vs resolved, and two-dimensional charts

  4. Use Jira gadgets to display detailed Jira reports and charts on pages

  5. Use Jira Charts for Confluence add-ons to customise and add features to your charts

Whether you’re sharing the progress of a sprint with marketing, senior management, or the whole company, you’ll probably want to share it in Confluence. If Jira is the collaboration tool for Software teams, Confluence is the best place to share updates with everyone not using Jira day-to-day.


The following is a handy guide to the different options, tools, tricks, and best practice for Atlassian’s Jira and Confluence reporting integrations. We’ll start with the simplest of integrations and reports, and gradually get more complex. There are some significant differences between Confluence Server and Cloud functionality. In this blog we’ll be using Confluence Cloud for the screenshots, and adding notes to any differences found on Confluence Server.


Out of the Box Jira and Confluence Integrations:

💽 Server and Data Center: Before you can use any of these macros, your Jira and Confluence applications must be connected via Application Links.

☁️ Cloud: Application links are automatically configured between Jira and Confluence, so you don't need to do anything 👍


Adding a Jira Issue/ Filter Macro to Confluence Pages

You can display a list of issues or a single issue, based on whatever Jira Query Language (JQL) search, filter, or URL you put into the macro. You can also create a new Jira Issue from within the macro, without leaving the Confluence page. Here you’ll also have the option to select and display a recently viewed issue. Finally, there’s even the option to display a count of issues.


To insert this macro, or any other macros onto a Confluence, you have a few options:


Select a macro from the quick links section


View all macros from the full menu

Top Tip: You can access the macros page directly with the keyboard shortcut ⌘+⇧+A on Mac or Alt+⇧+A on PC

If you already know the name of the macro you want to use, the easiest way to insert it is to type the curly brace { on the page, and start typing the name of the macro.


☁️ Cloud: The new Cloud page editor users forward slash / to open the quick search 🚀


Create a Jira Report Blueprint from a template

If you want to keep things simple, you can create a change log or a status report, without using Jira Query Language.


To create a Confluence page from a template, click create page, search for Jira, and then select Jira report.



Creating a standard static change log couldn’t be easier, just select the Jira project you want, and give it a title.



As soon as you hit create, you’ll see a static list of Jira Issues displaying in the change log.


If you want to create a dynamic Jira change log, go back to the change log settings screen and Switch to advanced.

Then enter your JQL query, or paste in the URL of the Jira search (find out more about using JQL in the Jira Documentation). This creates a dynamic report page in Confluence, summarising the Jira issues as defined by your Jira Query.


This dynamic Confluence macro will update automatically, whenever the relevant issues are updated.


For a more detailed summary, check out the Atlassian documentation page for the Jira Issues macro.


Create a Jira Status Report in Confluence

As before, click create page, search for Jira, and select Jira report, but this time select Status report.


The Jira status report displays the progress of your chosen Jira project and the fix version in pie charts. You can chart by assignee, project, component, reporter, resolution, sprint, priority or issue type. The status report uses the Jira Chart macro, and is based on the information you enter. It’s also a dynamic chart, so your Confluence report will update whenever your Jira Issue tickets are changed.


To create your own charts, you can just edit a Confluence page and type:

{Jira Charts

This will give you a selection of charts to choose from:

  • Pie Chart: which we’ve covered.

  • Created vs Resolved: which compares the number of issues created with the number of issues resolved on a line graph.

  • Two Dimensional: which displays a grid of statistics. Choose from: Status, Fix version, Assignee name, Priority, Component, and Issue type and more.

Customizing Jira Charts in Confluence Reporting Blueprint Templates

Out of the box, the only customizations you can do to the blueprint templates are:

  • Move them around the page, or delete any chart you don’t want to be included

  • Set the width of each chart

  • Toggle the chart border on or off

  • Choose whether to display chart information

  • Change the name of some headings, and modify the instructional text

If those “customizations” seemed limited, there are a number of Macro Apps that offer many more customization options.


Custom Jira Charts for Confluence

Custom Jira Charts for Confluence offers the following customizations:

  • Choose the colors of Pie Chart segments, Funnel, or Bar Charts using a color picker or hex code

  • Rearrange the order of the segments from high to low or low to high with a click, or drag and drop in any custom order

  • Chart by assignee, project, component, reporter, resolution, sprint, priority or issue type and user-created custom fields

  • Show / hide segments you don't want to see

Once you’ve installed it, either type {Custom or search for "Charts" in the macro selector

The Custom Jira Charts for Confluence editor


To get started and see it for yourself check out the Custom Jira Charts for Confluence Playground here. Available on Cloud, Server and Data Center!


Visit the Atlassian Marketplace for Custom Jira Charts for Confluence to find out more.


To make a Jira chart in Confluence for tasks resolved within a specific time


For this advanced report, you'll need an app like Table Filter and Charts by Stiltsoft. First, combine their Chart from Table macro and their Pivot Table Macro.


Now you can visualise the distribution of tasks that were resolved within the dates you defined for the project.


Or you can find out the most active issue reporters for a specific project within some period of time and show their number of issues in the form of the bar chart.


Check out the video below for a demo:


This advanced combo move of macros allows a lot of customised reporting options for power users. If you know what you’re doing, you can quickly and easily apply the right filters, and choose the right data set all from within page view mode, with no need to hit the edit page button.


So as you can see, there is an abundance of options for reporting and charting of Jira issues in Confluence, depending on your needs.


We haven’t even gotten into many excellent roadmap tools that link Jira with Confluence.

But that’s another story for another blog. For now, check out the Custom Jira Charts for Confluence playground, and see what you could do with some more customizable options in your Jira Charts Reporting.