JIRA Charting Plugin

Name JIRA Charting Plugin
Vendor Atlassian Pty Ltd (Website)
Authors Atlassian
Homepage http://confluence.atlassian.com/display/JIRAEXT/JIRA+Charting+Plugin
Issue Management http://developer.atlassian.com/jira/browse/JCHART
Categories Content
Version 1.4
Availability JIRA v3.13 to v3.13
State Stable
Support Atlassian Supported Plugins
License Freeware / Open Source (BSD)
Price Free
Release Docs http://confluence.atlassian.com/display/JIRAEXT/JIRA+Charting+Plugin
Java API Docs n/a
Download Source http://svn.atlassian.com/svn/public/contrib/jira/jira-charting-plugin/tags/jira-charting-plugin-1.4/
Download JAR jira-charting-plugin-1.4.jar

Compatibility With JIRA

Plugin Version 3.10.2 3.11 3.12.3 3.13 Tested Supported
1.3.11   David Chui (Jan/28/2008)
1.3.13   David Chui (May/06/2008)
1.4 Brad Baker (Aug/29/2008)

Download older versions

The Charting plugin does not work with Sybase ASE. See JCHART-17 and JCHART-21.

If you are using SQL Server as a database, please make sure you are using 1.2.10 or higher, which fixes a bug that caused search index lock problems.
If JIRA issues have been imported from an external system:
The charting plugin cannot calculate resolution dates for issues that were resolved prior to CSV import. Please vote on JCHART-41 to see this feature in a future release.

Description/Features

A plugin providing various charts and reports for JIRA.
These charts and reports provide a visual representation of a project or a saved filter in different contexts.

In general, charts are:

  • run over any saved filter or project
  • for a period of X days previous to the current date
  • broken down into incremental periods of hours, days, weeks, months, quarters or years.
  • hyperlinked to relevant issues in the Issue Navigator
  • linked to a relevant report showing a larger chart, as well as a detailed data table

Portlets and Reports

The plugin currently includes the following charts (each with associated portlet and report), which are:

  • Recently Created Issues - a bar chart showing the issues recently created.
    • The green portion of the bar shows the created issues which are resolved, the red portion shows created but as yet unresolved issues.
    • This visually shows both how quickly you're creating issues, as well as how many of those created issues are resolved.
  • Created vs Resolved Issues - a difference chart showing the issues created vs resolved over a given period.
    • This chart can either be cumulative or not.
    • Areas in red show periods where more issues were created than resolved, areas in green show periods where more were resolved than created.
    • Versions can also be added to this chart, showing you how issue creation & resolution related to releases
  • Resolution Time - a bar chart showing the average resolution time (in days) of resolved issues.
    • This is useful to show you over time whether your team is getting better or worse at resolving issues in a timely fashion.
  • Average-Age Open Issues - a bar chart showing the average number of days that issues have been unresolved
    • This chart displays the average of how long issues remain open on a specified interval (e.g. daily, weekly, etc.)
  • Pie Chart - display issues from a project or filter grouped by a statistic type in pie-chart format
    • The issues can be grouped by any statistic type (e.g. Status, Priority, etc.)
  • Average Time in Status - displays the average number of days issues have spent in a status.
  • Average Number of Times in Status - displays the average number of times an issues has been in a status.
  • Time to First Response - displays the number of hours taken to respond to issues in a project or for a filter. Portlet only (i.e. not available as a report).
  • Time Since Chart - For any chosen date field, shows a bar chart with number of issues with the chosen date field set on that date.

'Charting' View for Issue Navigator

The JIRA Charting Plugin now integrates with your issue navigator. When viewing search results you can click the 'Chart' option in the issue navigator views to popup an instant chart view.

From the chart view popup you have the option to configure any chart that is available via the charting plugin. Once happy with your chart and its configuration you can, in one step, create a named filter and save the chart to any page on your dashboard.

Custom Fields

  • Resolution Date - required to be installed, this custom field indexes issue resolution dates (for fast querying during charting) but also allows you to add resolution date into any filter or search. For example: show me all issues resolved during this week or in the last 30 days. This field can of course be combined with other search fields.
  • First Response Date - required to be installed, this custom field indexes the date of the first comment that is not by the reporter (for fast querying during charting) but also allows you to add this date into any filter or search.
  • Time in Status - Stores statistics about the amount of time/times an issue has spent/been in its statuses. This field is used to generate the Average Number of Times Spent In Status and Average Time Spent In Status Charts.
    Please Sir, can I have some more?
    I'm always looking for suggestions of new charts to add to this plugin. If you've got a suggestion please raise a feature request with specific details on exactly what data the chart should show, where the data comes from and why it's useful.
    Need support? Please see our support page for details.

Usage and Installation

MS SQL Server users please upgrade

The 1.1.1 version of the plugin caused problems on MS SQL Server and possibly other databases. Please upgrade the plugin to version 1.1.2.

Headless Mode

You may need to run Java in Headless Mode. This is accomplished by setting the VM variable - -Djava.awt.headless=true

  1. Install the plugin by copying the JAR to WEB-INF/lib inside your JIRA web application and restart JIRA.
    • Note: You must restart JIRA after this step, before the next!
    • Note: The next three fields must be added as their respective Custom Field types (Do not add these fields as type Date Picker).
  2. Go to Administration > Custom Fields and add a new custom field of the type Resolution Date. Do not add this field to any workflow transition screens (e.g. Resolve screen), but if you want you could display it on the default ("view issue") screen.
    • Recommendation: name the custom field "Resolution Date"
    • Warning: make sure the searcher is set to "Date Picker" (bonus: this means you can now search and filter by date resolved!)
  3. Go to Administration > Custom Fields and add a new custom field of the type Date of First Response. Do not add the field to any (transition) screens.
    • Warning: make sure the _searcher is set to "Date Picker" (bonus: this means you can now search and filter by date of the first comment!)
  4. Go to Administration > Custom Fields and add a new custom field of the type Time in Status. Do not add the field to any (transition) screens.
    • Warning: make sure the searcher is set to "Free Text Searcher" (NOTE: you will not want to put this field on any screens as the data it stores is not in human readable format)
  5. Go to Administration > Indexing and re-index your JIRA data.
  6. Now you can add new chart portlets to your Dashboard, or view reports from any projects Browse Project page.
    • Note: I've tried to do as much intelligent cross linking as possible. All chart portlets are linked through to relevant report for more detail, and all charts elements (bars, points etc) are linked to a relevant issue search showing you the issues which make up that element.
      Please do not add the Resolution Date custom field to any Resolve Issue Screens, this can make it so that the resolution date is calculated incorrectly if the issue does not yet have any change history.

Additional Notes

  1. Internet Explorer users will need to configure the 'Temporary Internet file' settings of their browsers, to be able to print pages with charts correctly.
    The Internet Explorer cache should be set to check for newer versions of stored pages 'Automatically', not 'Every visit to the page' (i.e. no caching).
    For full instructions, see the relevant section of the user guide here.

Version History

Plugin Versions

Version Date State License Price
Show description 1.4 (#30) 01 Sep 2008 Stable Freeware / Open Source (BSD) Free

Release Notes

Updated to be API compatibale with JIRA 3.13

Contributors

  • Atlassian — Developer

Show description 1.3.13 (#29) 06 May 2008 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixed incompatibility with Firebird database.

Contributors

  • Atlassian — Developer

Show description 1.3.11 (#28) 29 Oct 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixed an InvalidMethodException that was sometimes being fired.

Contributors

  • Atlassian — Developer

Show description 1.3.10 (#27) 16 Sep 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Updated to use Lucene 2.2 in line with JIRA 3.11.

Contributors

  • Atlassian — Developer

Show description 1.3.9 (#26) 21 Jun 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixes JCHART-165 (Links were not being disabled properly on the issue navigator chart) JCHART-166 (Number of issues was no longer being shown in the section labels for pie charts).

Contributors

  • Atlassian — Developer

Show description 1.3.8 (#25) 06 Jun 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Compatibility release for JIRA 3.10 feature JRA-12844, only required for JIRA 3.10 - no functional differences otherwise.

Contributors

  • Atlassian — Developer

Show description 1.3.7 (#24) 27 May 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixes JCHART-164 (when there were exactly eight segments in the pie chart two adjacent segments had the same colour).

Contributors

  • Atlassian — Developer

Show description 1.3.6 (#23) 09 May 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixes JCHART-50 Resolution date and Date of first response are now datetime customfields.

Contributors

  • Atlassian — Developer

Show description 1.3.5 (#22) 16 Apr 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixes JCHART-149 Proper fix for concurrency bug in the older version of JFreeChart.

Contributors

  • Atlassian — Developer

Show description 1.3.4 (#21) 05 Mar 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixes JCHART-149 Work-around for concurrency bug in the version of JFreeChart being used and JCHART-150 Improved validation for input variables.

Contributors

  • Atlassian — Developer

Show description 1.3.3 (#20) 06 Feb 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixes HSQL issues JCHART-145 and JCHART-147.

Contributors

  • Atlassian — Developer

Show description 1.3.2 (#19) 29 Jan 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

The charting plugin no longer uses the user configured value for the Base URL. This was causing problems for users who had an incorrectly configured Base URL (see JCHART-140 and JCHART-141)

Contributors

  • Atlassian — Developer

Show description 1.3.1 (#18) 29 Dec 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Charting plugin now uses JIRA's lazy loading instead of its own.

Contributors

  • Atlassian — Developer

Show description 1.3 (#17) 17 Dec 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Contains the 'Charting' View for Issue Navigator and may JCHART bug fixes.

Contributors

  • Atlassian — Developer

Show description 1.2.13 (#16) 29 Nov 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixes for JCHART-98 and JCHART-99.

Contributors

  • Atlassian — Developer

Show description 1.2.11 (#15) 22 Oct 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Contains Fixes for: JCHART-67 (case-sensitivity problem in Sybase) - note Sybase still appears broken.

Contributors

  • Atlassian — Developer

Show description 1.2.10 (#14) 26 Sep 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Contains Fixes for: JCHART-79 (problems with the time in status field on MS-SQL).

Contributors

  • Atlassian — Developer

Show description 1.2.9 (#13) 18 Sep 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Contains Fixes for JCHART-84 (problems with saving status in the average time in status graph) and JCHART-84 (Safari browser problems with lazy loading).

Contributors

  • Atlassian — Developer

Show description 1.2.7 (#12) 07 Sep 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Created a new Time Since Chart. Any date field can be chosen, the chart then shows a bar chart with number of issues with the date field set on that date.

Contributors

  • Atlassian — Developer

Show description 1.2.6 (#11) 09 Aug 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Charts viewed via the RunPortlet Servlet no longer lazy load (important when charts are viewed via Confluence). Missing entries in the properties files have been added.

Contributors

  • Atlassian — Developer

Show description 1.2.5 (#10) 09 Aug 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Made all the portlets lazy loading. Portlets now show a place-holder until the graph is generated. Please note that this version of the plugin requires JIRA 3.6.3 and above.

Contributors

  • Atlassian — Developer

Show description 1.2.4 (#9) 09 Aug 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Added Time in status custom field and the Average Time in Status and Average Number of Times in Status charts. Please note that this version of the plugin requires JIRA 3.6.3 and above.

Contributors

  • Atlassian — Developer

Show description 1.2.3 (#8) 26 May 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Added time until first comment chart and custom field. Images now have width and height attributes.

Contributors

  • Atlassian — Developer

Show description 1.2.2 (#7) 26 May 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixed JCHART-39.

Contributors

  • Atlassian — Developer

Show description 1.2.1 (#6) 26 May 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixed JCHART-35 / JRA-9894.

Contributors

  • Atlassian — Developer

Show description 1.2 (#5) 25 May 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Added Pie Charts and Average Age reports and portlets.

Contributors

  • Atlassian — Developer

Show description 1.1.2 (#4) 19 Feb 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Fixed incompatibility with MS SQL Server - JCHART-19

Contributors

  • Atlassian — Developer

Show description 1.1.1 (#3) 31 Jan 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Updated to work with JIRA 3.5. No functional changes.

Contributors

  • Atlassian — Developer

Show description 1.1 (#2) 28 Jan 2007 Stable Freeware / Open Source (BSD) Free

Release Notes

Improve performance when handling incorrect data, improved internationalisation support (french bundled).

Contributors

  • Atlassian — Developer

Show description 1.0 (#1) 17 Jan 2006 Stable Freeware / Open Source (BSD) Free

Release Notes

Initial checkin - includes "Recently Created", "Created vs Resolved" and "Resolution Time" charts and reports.

Contributors

  • Atlassian — Developer

Open Issues

Atlassian Developer Network JIRA (25 issues)
T Key Summary Reporter Status
Bug JCHART-95 Possible i18n Problem Bernd Mattern Open
Bug JCHART-177 can only get pie charts to work Megan Sumrell Open
Bug JCHART-20 There are only added a resolution date if closed from ReOpened jakob Gormsen Open
Bug JCHART-241 The "TimeInStatusCFType" does not keep the database and index consistent. Brenden Bain Open
Bug JCHART-238 NullPointerException thrown when trying to look at "Average Time In Status" graph. Brenden Bain Open
Bug JCHART-237 When Pie chart is backed off a custom field the title displays a key instead of the field name Nick Menere Open
Bug JCHART-23 by reverse proxy, ERROR 500, jfreechart graph does not exist Chenggong LV Open
Bug JCHART-231 Creating a vcard cause an !!ACK!! Nick Menere Open
Bug JCHART-226 Unresolved issues showing up as resolved on Created vs Resolved report Erin Barschdorf Open
Bug JCHART-215 Reports from Charting plugin are listed in French while my JIRA profile is set to English when browsing projects Phil Rob Open