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
- Edit the page and type
/Jira chart (Chartmere). - Enter the JQL, such as
project = HELPfor a service desk orproject = WEB AND type = Bugfor a bug trend. - Choose Created vs resolved.
- Pick the period: day, week, month, quarter or year.
- 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.
- Turn on running totals and the unresolved trend if you want them.
- Press Save, then publish.
Rolling or fixed dates
| Pick | When |
|---|---|
| Last N days | A page people check any time, such as a team's home page. The chart always ends today. |
| Fixed | A 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 know | JQL | Period |
|---|---|---|
| Is the support queue under control? | project = HELP | Week, running totals on |
| Are bugs piling up before a release? | project = WEB AND type = Bug | Week, 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 = Payments | Week, 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.