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

SectionChartSettings
Where things standStacked barBars by Team or Component, stacked by Status category
Who has whatTwo-dimensional tableRows by Assignee, columns by Status, with totals
Is the backlog growing?Created vs resolvedBy week, running totals on
What got doneLine over timeResolved date by week, sum of Story point estimate
RisksBarPriority, 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

  1. Pick the JQL once, such as project = WEB AND updated >= -30d, or save it as a Jira filter and use filter = 12345 in every chart so they always agree.
  2. 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.
  3. 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.
  4. Publish. Readers see the charts counted from what they can browse.
  5. 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.
  6. 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 whenUse a snapshot when
The page is a dashboard people check any dayThe page is a report for a date
Readers all have Jira accessSome readers don't have Jira access
Numbers should match Jira right nowNumbers 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() and issueHistory(), 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


More Confluence guides