How can I automatically display a Jira burndown chart and sprint report in Confluence?

[Jim Tailor]

I’m creating a Confluence page to keep stakeholders informed about our development progress. I’d like to automatically embed a Jira burndown chart and sprint report into the page instead of manually recreating or updating them each time.

Is there a way to make this process automated or at least achievable in a single action so the data stays up to date?

[Alexey Pavlenko _App Developer_]

Hi @Jim Tailor ,

For the Sprint Burndown Gadget, just type on the confluence page:

 /Sprint Burndown Gadget

For the Sprint Report, I would suggest using the app I developed - Multi-team Scrum Metrics & Retrospective. First add it to a JIRA dashboard and after that add the link to the dashboard to the confluence page, it will automatically be transformed it into a preview.

3 boards/teams in the same view, 1 period selected for analysis:

3 boards/teams in the same view, all periods are clicked for average metrics:

Btw, have you considered JIRA Dashboard for the reporting? It has native Sprint Burndown Gadget as well.

Best regards,
Alexey

[Danut M _StonikByte_]

Hi @Jim Tailor ,

Welcome to Atlassian Community. 

You can display the sprint burndown chart by embedding the Jira's Sprint Burndown macro in your Sprint Report page.

But, as far as I know, there is no way to embed the Jira Sprint Report in a Confluence page. But you could eventually try to use macros like Sprint Health or Filter Results instead.

Another possibility is to make use of an app (plugin) from Atlassian Marketplace. 

If you consider using a plugin, our Great Gadgets app for Confluence offers all you need for building an effective report page for your sprint, project or sprint in Confluence.

It offers a Sprint Burndown Burnup Chart macro that allows you to display both the sprint burddown and the sprint report (similar to the one from jira). 

In addition, it offers additional macros such as Release Burndown Burnup Chart (with forecast), Team Velocity, epic progress and many others for an effective real-time report page in Confluence. 

Another option is to use our Great Gadgets for Jira Cloud app, add the gadgets you need in a Jira dashboard, then copy their link and paste it in Confluence pages. But the previous option, with native Confluence macros, works much better in my opinion. 

Hope this helps.

Danut.  

[Vasyl Krokha _Broken Build_]

Hi Jim!

The problem: You want to automatically display burndown charts and sprint reports on a Confluence page to keep stakeholders informed - without manual effort each time. Manually recreating charts on Confluence each sprint is tedious and error-prone - stakeholders need live data, not stale screenshots.

The solution: You can achieve this by saving your chart as a Jira dashboard gadget using Agile Reports and Gadgets - featuring Sprint Burnup/Burndown charts, Sprint Velocity charts, and many other powerful Agile reporting tools. With Jira Smart Links, you can embed dashboard gadgets directly in Confluence - no extra plugins required. The chart updates automatically, so stakeholders always see current data without any manual steps.

How it works:

1. Create a Sprint/Daily Burndown chart in the app, configured for your board and sprint.

2. Save the chart as a gadget using Save as a gadget or create a chart directly on the dashboard.

3. Open the chart on the dashboard and click the link icon in the top-right corner of the gadget to copy the link.

4. Paste the link into any Confluence page. Confluence converts it into a Smart Link preview and embeds the chart.

The embedded chart in Confluence is fully interactive:

• You can open the chart settings
• Adjust filters, grouping, or calculations
• Save changes, and they will apply to the original dashboard gadget as well

Because Smart Links render the actual dashboard gadget, Confluence always shows the most up-to-date chart state.

Feel free to ask if you need any help with the setup - happy to assist!

[Marc -Devoteam-]

HI @Jim Tailor 

Welcome to the community.

This could be done by creating a template on the Confluence space.

You would need to get the content of an empty Confluence page based on this template

The remaining issue is that you would still need to update the related macros, based on the Sprint name/ID.

Based on automation, you could then create a new page, when closing the sprint. You would have to do this via an API call (web request action in automation)

You would first need to create a variable that stores the sprint name or ID, then based on the JSON of the template confluence page, do a web request action, in that action the full content of the page should be in the post of the web request, using the variable in this content, where the macro's are used for the burndown and sprint report so it places the name or id of the sprint in these macro's.

Its a very technological solution, to achieve this, but it can be done via automation.