How to build a Jira status report in Confluence
By Jake Marsh · Updated
To build a Jira status report in Confluence, make a page with a few Chartmere charts over the same JQL: a stacked bar of work by status, a two-dimensional table of assignee by status, and a line of work resolved per week. Each chart is live for the reader and links every number to its work items in Jira. At the end of each period, press Take snapshot on each chart to freeze the numbers with the date, and copy the page for next time.
A report page that works
| Section | Chart | Settings |
|---|---|---|
| Where things stand | Stacked bar | Bars by Team or Component, stacked by Status category |
| Who has what | Two-dimensional table | Rows by Assignee, columns by Status, with totals |
| Is the backlog growing? | Created vs resolved | By week, running totals on |
| What got done | Line over time | Resolved date by week, sum of Story point estimate |
| Risks | Bar | Priority, JQL adds statusCategory != Done AND priority in (Highest, High) |
Write a sentence or two above each chart about what changed. The charts carry the numbers; the text says why they matter.
Steps
- Pick the JQL once, such as
project = WEB AND updated >= -30d, or save it as a Jira filter and usefilter = 12345in every chart so they always agree. - Edit the page and type /Jira chart (Chartmere) for each chart, choose the type and fields from the table above, and press Save. Save checks the JQL with Jira.
- Add reader filters, up to three per chart, such as Team or Component, so each lead can narrow the page to their part without a copy of it.
- Publish. Readers see the charts counted from what they can browse.
- At the end of the period, press Take snapshot on each chart. The values, date and who took it are frozen for everyone who can view the page, including people without Jira access.
- Next period, copy the page and take fresh snapshots on the copy, so each report keeps its own numbers.
Live or snapshot?
| Use a live chart when | Use a snapshot when |
|---|---|
| The page is a dashboard people check any day | The page is a report for a date |
| Readers all have Jira access | Some readers don't have Jira access |
| Numbers should match Jira right now | Numbers should never change after sign-off |
Only page editors can take or replace a snapshot. If you change a chart's settings so it needs other fields, take a new snapshot.
Exporting the report
PDF and Word exports carry each chart as a picture and its numbers as a table, so the document matches the page. Live charts export as counted for the person exporting, snapshots as frozen. That makes a snapshot the right choice for a report you'll send as a PDF.
Things to watch
currentUser()in the JQL means the person reading. Good for "my work" pages, not for a team report.- Functions that answer differently per person, such as
watchedIssues()andissueHistory(), are refused in live charts. Write explicit values instead. - A chart reads up to 5,000 work items by default, and says so when a result is bigger.
Chartmere starts with Atlassian's 30-day free trial; prices are on the Chartmere page.
What it costs
Chartmere is From $11 a month for up to 10 users. Every plan and the install link are on the Chartmere page.
Chartmere: Work Item Charts and Reports for Confluence
Jira charts on Confluence pages: pie, bar, stacked, line, created vs resolved and 2D tables from any JQL, counted for each reader From $11 a month for up to 10 users.
Questions
Can I embed a Jira dashboard in Confluence instead?
Confluence can show a Jira dashboard to readers who have Jira access. Chartmere charts are part of the page itself, can be frozen as snapshots, and export to PDF and Word with their numbers.
How do I make every chart on the page use the same work items?
Save the JQL as a Jira filter and use filter = <id> in each chart.
Can readers without Jira access read the report?
Yes, through snapshots. Live charts need a signed-in reader who can browse the work items.
Can the report show sprint progress?
Yes. Group by Sprint, or use sprint in openSprints() in the JQL and group by status.
More Chartmere guides
- How to add a created vs resolved chart to Confluence
- How to add a Jira bar chart to a Confluence page