How to add a created vs resolved chart to Confluence

By Jake Marsh · Updated

A created vs resolved chart shows how many work items were created and how many were resolved in each period, so you can see whether a backlog is growing or shrinking. To add one in Confluence with Chartmere, type /Jira chart (Chartmere) on the page, enter your JQL, choose Created vs resolved, pick the period (day, week, month, quarter or year), choose rolling or fixed dates, turn on running totals if you want them, and press Save.

Reading the chart

  • Created and resolved per period: two series side by side. When created stays above resolved, work is coming in faster than it's finished.
  • Running totals: each series adds up from the start of the range, which makes a slow drift easier to see than week-by-week bars.
  • Unresolved trend: how many work items were still open at the end of each period.

The created and resolved numbers in the table under the chart link to the work items behind them in Jira.

Steps

  1. Edit the page and type /Jira chart (Chartmere).
  2. Enter the JQL, such as project = HELP for a service desk or project = WEB AND type = Bug for a bug trend.
  3. Choose Created vs resolved.
  4. Pick the period: day, week, month, quarter or year.
  5. Choose the dates: a rolling range of the last N days (90 by default), or fixed start and end dates for a report about one quarter.
  6. Turn on running totals and the unresolved trend if you want them.
  7. Press Save, then publish.

Rolling or fixed dates

PickWhen
Last N daysA page people check any time, such as a team's home page. The chart always ends today.
FixedA report about a set period, such as Q3, that should cover the same dates whenever it's read.

For a report that must never change after it's signed off, press Take snapshot on the published page as well. The values are frozen with the date and who took them.

Compared with the built-in macro

Confluence's own Jira chart macro also has a created vs resolved chart. Chartmere's adds running totals, the unresolved trend, fixed date ranges, numbers that link to their work items, reader filters and snapshots, and it exports to PDF and Word with the chart as a picture and its numbers as a table.

Examples

You want to knowJQLPeriod
Is the support queue under control?project = HELPWeek, running totals on
Are bugs piling up before a release?project = WEB AND type = BugWeek, fixed dates for the release cycle
How did the year go?project in (WEB, APP)Month, fixed dates for the year
Is one component getting worse?component = PaymentsWeek, rolling

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

What counts as resolved?

Work items with a resolution date in the period, as Jira records it.

Can I split created vs resolved by team?

Add a reader filter for Team so each reader can narrow the chart, or use one chart per team with the team in the JQL.

Does it work for Jira Service Management requests?

It charts any work items your JQL finds and you can browse, including requests in service spaces.

Can readers change the date range?

No. The range is part of the chart settings. Readers can narrow the chart with the reader filters you offer.


More Chartmere guides


More Confluence guides