Charting Plugin Pending feature

Name Charting Plugin + Pending functionalities
Version 1.0 / Based on 1.2 version of the official charting plugin
1.3.3 / Based on 1.3.9 version of the official charting plugin
Product Versions Atlassian JIRA 3.5 / 3.6
Atlassian JIRA 3.8.1 - 3.9.x
Author(s) Mike Cannon-Brookes / Pierrick Perret
1.3.x upgrades by Benjamin Duchene
Homepage  
Price free
License
JavaDocs  
IssueTracking  
Download JAR jira-charting-plugin-1.2.jarjira-charting-plugin-1.2-1.jar
jira-charting-plugin-pending-1.3.3.jarjira-charting-plugin-pending-1.3.4.jar
jira-charting-plugin-1.3.14.jar
Download Source Jira-Charting-Plugin-Pending-1.0.zip| Jira-Charting-Plugin-Pending-1.2-1.zip
jira-charting-plugin-pending-1.3.3.zip

Description/Features

This plugin is an extension of the official Jira Charting Plugin including pending issues chart features. It has been implemented on the basis of the 1.2 version of the Jira charting plugin. You could look at the following URL http://confluence.atlassian.com/display/JIRAEXT/JIRA+Charting+Plugin to know what are the original functionalities.

In this version, 2 new charts have been added :

  • A simple line chart wich shows pending stock issues evolution (see attachment).
  • An extension of the "created vs resolved" chart which includes a 3rd line showing the pending stock issues evolution (see attachment).

For each day of the period the plugin compares the date with the creating and resolving dates of issues. So it could determine for each day how many issues were "pending" and display it into the chart.








Usage

It could be used to track the evolution of the pending issues stock over a specific period. This view/indicator is useful for project manager to see the trend of their issues stock.

Warning : At the moment you couldn't use this plugin and the official charting plugin. It will make conflicts. We suggest that you test it into a test instance before to use it in a production environment.

Examples

Version History

1.2 : initial version

1.2-1: Bug fix for the calculation of the superior bound. 

1.3 : features ported to 1.3.7 version of the official Jira Charting Plugin

1.3.1 : bug fix on pending chart + some minor cosmetic fixes

1.3.2 : bug fix on portlet feature

1.3.3 : now based on the official Jira Charting Plugin 1.3.9 and another bug fix on pending chart on portlet feature

Screenshots



Labels

plugin plugin Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
  1. May 09, 2006

    Benjamin Joguet says:

    Where is the jar file ?

    Where is the jar file ?

    1. May 11, 2006

      Pierrick says:

      Hi Benjamin, The wiki page wasn't finished. The jar file and source code have ju...

      Hi Benjamin, The wiki page wasn't finished. The jar file and source code have just been added. Thanks. Pierrick.

  2. Aug 31, 2006

    Brett Adam says:

    Could someone please integrate this into the JIRA Charting Plugin? Seems like a ...

    Could someone please integrate this into the JIRA Charting Plugin? Seems like a darn useful "extra" that is currently forked and thus unusable in conjunction with the base charting plugin.

    1. Aug 31, 2006

      Nick Menere says:

      Brett, I have added a task

      Brett,
      I have added a task to do this. Though Hamish is busy at the moment so...

      Cheers,
      Nick

  3. Oct 24, 2006

    Buhi Mume says:

    I am trying to understand the "Created vs. Resolved and Pending" report. Conside...

    I am trying to understand the "Created vs. Resolved and Pending" report. Consider the points from 23-May onwards. During that period, the number of resolved issues is always greater than the number of created issues. However, the yellow line, i.e. pending issues, is pretty much flat. Is it intuitive to expect the yellow line to slope down because the rate of resolving is greater than creating. It seems that the yellow line also considers the re-opened issues. If this is indeed the case, will the following quote from the description still be valid?

    For each day of the period the plugin compare the concerned date with the creating and resolving dates of issues. So it could determine for each day how many issues were "pending" and display it into the chart.

    I might have missed some important information here, but how is the number of pending issues inferred from created and resolved issues?

  4. Oct 24, 2006

    Pierrick says:

    Hi Buhi, Lines displaying created and resolved are cumulatives curves. In this e...

    Hi Buhi,
    Lines displaying created and resolved are cumulatives curves. In this exemple, it shows that no issues have been resolved and no issues have been created from the 23th of May to the end of the period displayed by the chart. As a consequence, the yellow line is flat, because the stock is always the same.

    For information, you can choose if you want to see these  lines cumulated or not when you setup the report.

    Hope this help.
    Cheers. Pierrick

  5. Oct 27, 2006

    Jeff Fry says:

    Hi Mike and Pierrick, Thanks for this plugin \  'Created, Resolved ...

    Hi Mike and Pierrick,

    Thanks for this plugin -  'Created, Resolved Issues and Pending Stock' is a report I've been wanting. It doesn't work perfectly for me yet, but I know it's still in development and is already helping me. A few issues:

    1. Pending Stock: How is it calculated? I was assuming that it would equal the count of unresolved issues for that filter. Should that be true? I'm finding it to be somewhat higher than the number of unresolved items in the filter.

    2. So far when I try /Pending Issues Stock Evolution' I just get ' No chart created. Possibly invalid project or saved filter selected?' - whether I select a filter or a project.

    1. Oct 30, 2006

      Pierrick says:

      Hi Jeff, sorry for the delay... About the first point you mentionned, theorical...

      Hi Jeff, sorry for the delay...

      About the first point you mentionned, theorically, the yellow line counts how many issues were pending for each day of the period. => day positionned after the creation date and before the resolution date (+ issues that didn't have a resolution date filed in).
      Here is an extract of a report I ran recently:

      27-October-2006 16 12 32
      28-October-2006 0 0 36
      29-October-2006 0 0 36
      30-October-2006 8 14 36

      How to read this result:

      • 27-OCT: Pending stock = 32 issues; activity of the day 16 creations and 12 resolutions
      • 28-OCT: Pending stock (considering previous day's activity) = 32+16-12 = 36
      • ...
      • What will be displayed on the 1st nov: 36+8-14=30
        The second point you are talking about, let me think that perhpas you didn't install the "Resolution Date" customfield, is it right? A new customfield type is embeded into the plugin (same as the original Jira charting plugin ).
        You need to add it (Administration / Customfields), and to make a reindex after (Adminstration / Indexing). Could you try and let me know?

      Hope this helps.
      Cheers, Pierrick.

      1. Nov 03, 2006

        Jeff Fry says:

        Hi Pierrick, Ahhh, now I understand what the discrepency is. My pending stock ha...

        Hi Pierrick,

        Ahhh, now I understand what the discrepency is. My pending stock has stayed consistantly ~ 10 more than my count of unresolved issues. When you mentioned going by resolution date, I did a search and found that I have 9 resolved items without resolution dates. Once I solve that, my pending stock should be totally accurate.

        Re my 2nd question, I do have the Resolution Date custom field installed. I re-indexed after reading your comment, but still get 'No chart created. Possibly invalid project or saved filter selected?' - whether I use any of many filters, or if I try entering an entire project.

        Thanks again, Jeff 

        1. Nov 13, 2006

          Pierrick says:

          Hi Jeff, Happy to see that the plugin gives information you are looking for. Abo...

          Hi Jeff,

          Happy to see that the plugin gives information you are looking for.

          About the second chart (Pending Issues Stock Evolution), I don't understand what can happen, because it should show exactly the same information but wihtout the view on created and resolved issues (only the pending stock evolution).

          What is your jira version ?

          Thanks. Pierrick. 

  6. Feb 06, 2007

    Aileen Cunningham says:

    Hi,  this plugin is exactly what I've been looking for but I'm seeing some ...

    Hi,

     this plug-in is exactly what I've been looking for but I'm seeing some problems getting the Created / Resolved / Pending report to work.

    As you can see from the extract below all the figures look correct up until the final "Pending" figure which falls to zero.

    Any ideas?

    thanks, Aileen

    Period Created Resolved Pending Issues Stock
    27-January-2007 0 0 93
    28-January-2007 0 0 93
    29-January-2007 2 7 93
    30-January-2007 4 0 88
    31-January-2007 4 3 92
    1-February-2007 5 1 93
    2-February-2007 3 0 97
    3-February-2007 0 1 100
    4-February-2007 0 0 99
    5-February-2007 2 8 99
    6-February-2007 0 1 0
    1. Feb 06, 2007

      Pierrick says:

      Yes you're right, that was a bug (already fixed \!).  Download the 1.21. Ch...

      Yes you're right, that was a bug (already fixed !).  Download the 1.2-1. Cheers, Pierrick.

  7. Feb 08, 2007

    Aileen Cunningham says:

    Working fine now thanks for your help, Aileen

    Working fine now - thanks for your help, Aileen

  8. Mar 21, 2007

    jonathon says:

    This is really cool but it's based on the old charting plugin. We don't want to ...

    This is really cool but it's based on the old charting plugin. We don't want to lose some of the new charting plugin functionality. Are there any plans to rebuild it on the basis of the latest charting plugin (1.3.4+)? I understand, of course, that you don't want to update it every time a new charting plugin version comes out but until Atlassian integrates something like this into their base product you could, perhaps, update it every few months?

  9. May 04, 2007

    Will Rau says:

    Any chance this can be updated for the latest charting plugin?  This is rea...

    Any chance this can be updated for the latest charting plugin?  This is really the chart I would love to have, but I can't get it to work with Jira 3.8+.

  10. Jun 20, 2007

    Benjamin Duchene says:

    \\ Well, I have updated the plugin, it works fine on Jira 3.8.1 and later But it...


    Well, I have updated the plugin, it works fine on Jira 3.8.1 and later

    But it does not on Jira 3.7.x and 3.8

  11. Jun 22, 2007

    Vincent Eggen says:

    Tested version 1.3 on Jira 3.9. Got the following exceptions on the "created, r...

    Tested version 1.3 on Jira 3.9.

    Got the following exceptions on the "created, resolved and pending" chart:

    2007-06-22 09:13:49,083 http-8080-Processor22 WARN [velocity] org.apache.velocity.runtime.exception.ReferenceException:
    reference : template = templates/charting/pending.vm [line 8,column 165] : $cumulative is not a valid reference.
    ...

    2007-06-22 09:13:49,083 http-8080-Processor22 WARN [velocity] org.apache.velocity.runtime.exception.ReferenceException:
    reference : template = templates/charting/pending.vm [line 8,column 191] : $versionLabels is not a valid reference.
    ...

    2007-06-22 09:13:49,083 http-8080-Processor22 WARN [velocity] org.apache.velocity.runtime.exception.ReferenceException:
    reference : template = templates/charting/pending.vm [line 1,column 30] : $numCreatedIssues is not a valid reference.
    ...

    2007-06-22 09:13:49,098 http-8080-Processor22 WARN [velocity] org.apache.velocity.runtime.exception.ReferenceException:
    reference : template = templates/charting/pending.vm [line 1,column 30] : $numResolvedIssues is not a valid reference.

    Any clue?

    Vince

    1. Jun 22, 2007

      Benjamin Duchene says:

      I have missed some vars in the template file... It is fixed in 1.3.1 Also correc...

      I have missed some vars in the template file... It is fixed in 1.3.1

      Also corrected bug about bad URLs generated on pending values, and a minor cosmetic bug (on pending report, column name was "created" instead of "pending issues stock")

      Regards,

      Benjamin

      1. Jun 26, 2007

        Vincent Eggen says:

        Retested version 1.3.2 on Jira 3.9. I'm still getting the following, but on the...

        Retested version 1.3.2 on Jira 3.9.

        I'm still getting the following, but on the pending stock issues chart I think:

        2007-06-26 13:12:16,961 http-8080-Processor22 WARN [velocity] org.apache.velocity.runtime.exception.ReferenceException:
        reference : template = templates/charting/pending.vm [line 8,column 165] : $cumulative is not a valid reference.
        ...
        
        2007-06-26 13:12:17,165 http-8080-Processor22 WARN [velocity] org.apache.velocity.runtime.exception.ReferenceException:
        reference : template = templates/charting/pending.vm [line 8,column 191] : $versionLabels is not a valid reference.
        ...

        Let me know if you need the full trace.

        1. Jul 01, 2007

          Benjamin Duchene says:

          Oh yes, this is the same problem that last time, but on the "more details" link,...

          Oh yes, this is the same problem that last time, but on the "more details" link, wich appears only on the portlet view.

          Edit : I just released 1.3.3 version, with this bug fixed and now based on official Jira Charting Plugin 1.3.9

          Regards,

          Benjamin

          1. Jul 01, 2007

            Vincent Eggen says:

            1.3.9 tested and confirmed ok with 3.9. Well done. Will be put in production soo...

            1.3.9 tested and confirmed ok with 3.9.
            Well done. Will be put in production soon.

            Thanks for your efforts.

            Rgds,

            Vince

  12. Nov 19, 2007

    Vincent Eggen says:

    Broken on 3.11. We got an error similar to

    Broken on 3.11.

    We got an error similar to http://jira.atlassian.com/browse/JRA-13363.
    I guess it's related to Lucene's version change.

    Any idea for a quick fix ?

    Thks,

    Vince

  13. Nov 30, 2007

    Marco Lessard says:

    Hello, I've fixed the plugin for Jira 3.11. The problem was related to Lucene ve...

    Hello, I've fixed the plugin for Jira 3.11.

    The problem was related to Lucene version change and Jira API changes.

    I've included new jira-charting-plugin-pending-1.3.4.jar and jira-charting-plugin-pending-1.3.4-src.zip here.

    This one will work only for Jira 3.11+

    1. Jan 09, 2008

      Amit Khullar says:

      I installed the jirachartingplugin1.3.11.jar and the jirachartingpluginpending1....

      I installed the jira-charting-plugin-1.3.11.jar and the jira-charting-plugin-pending-1.3.4.jar

      but still iam unable to see the above 2 reports with the pending stock feature i can only see the normal report from the jira-charting-plugin-1.3.11.jar plugin. Any ideas

      I am running Jira 3.11 

      1. Jan 10, 2008

        Pierrick says:

        Hi Amit, I have tested the plugin for the 3.11 and it seems to work like a charm...

        Hi Amit,

        I have tested the plugin for the 3.11 and it seems to work like a charm (thanks Marco for your contribution!). Are you trying to deploy both jira-charting-plugin-1.3.11 and jira-charting-plugin-pending-1.3.4.jar? If I'm right, I guess the 2 plugins are making conflicts. Could you test with only jira-charting-plugin-pending-1.3.4.jar (please ensure you removed jira-charting-plugin-1.3.11.jar).

        Thanks,

        Cheers, Pierrick.

        1. Jan 10, 2008

          Benjamin Duchene says:

          Hi, I confirm that the 2 plugins cannot work together, as the jirachartingplugin...

          Hi,

          I confirm that the 2 plugins cannot work together, as the jira-charting-plugin-pending includes all features of the official jira-charting-plugin.

          Benj

          1. Mar 24

            Ciro Coelho says:

            Hi, I'm using Jira 3.12 and I'm not able to see the plugin in the portlet option...

            Hi,

            I'm using Jira 3.12 and I'm not able to see the plugin in the portlet options nor in the plugin list. I also cannot see the charts I had previously configured with the plugin:

            WARNING: com.atlassian.jira.ext.charting:createdvsresolvedpending
            Portlets of this type have been disabled or removed from the system.

            I have got the jira-charting-plugin-pending-1.3.4.jar file and removed jira-charting-plugin-1.3.11 but then i get none of them.

            Any idea of what may be wrong?

            Thanks

               

            1. Apr 03

              William Crighton says:

              JIRA 3.12.1 uses Lucene v2 the latest plugin charting is based on a previous ver...

              JIRA 3.12.1 uses Lucene v2 - the latest plugin charting is based on a previous version of Lucene. The core Atlassian charting plugin has been modified to utilize Lucene v2 - this version is based on 1.3.9 of the JIRA plugin, which only supports ~v1.

              I have modified my version of the pending v1.3.3 plugin to work with JIRA 3.12.1 - let me know if you are interested in what I came up with (jar file). I'm next to email Mike and see what's required to accept my changes.  

              1. Apr 04

                Magnus Grimsell says:

                We are in the process of upgrading our production Jira to 3.12.2 so I would like...

                We are in the process of upgrading our production Jira to 3.12.2 so I would like to get my hands on your fix.

              2. Apr 04

                Ciro Coelho says:

                Yes, sure. I would appreciate it very much. Thanks in advance.

                Yes, sure. I would appreciate it very much.

                Thanks in advance.

              3. Apr 05

                Benjamin Duchene says:

                the 1.3.4 version of plugin by Marco Lessard still works with Lucene v2 and was ...

                the 1.3.4 version of plugin by Marco Lessard still works with Lucene v2 and was tested running with jira 3.11 (wich was the first release of Jira with Lucene v2)

                I don't know why it doesn't on jira 3.12... does anyone tested it successfully ? but the issue should not come from Lucene...

                1. Apr 08

                  Magnus Grimsell says:

                  I've just installed 3.12.2 and 1.3.4 seems to work fine with it.

                  I've just installed 3.12.2 and 1.3.4 seems to work fine with it.

                  1. May 16

                    gabriel says:

                    Problem: Don't see the plugin pending stuff with these jars installed: jirachart...

                    Problem: Don't see the plugin pending stuff with these jars installed:

                    jira-charting-plugin-1.3.13.jar 

                     jira-charting-plugin-pending-1.3.4.jar

                    Which versions of jars should I use with:
                     JIRA Enterprise Edition, Version: 3.12.3-#302

                    1. May 16

                      Benjamin Duchene says:

                      official "Jira charting plugin" and "charting plugin pending features" cannot wo...

                      official "Jira charting plugin" and "charting plugin + pending features" cannot work together.

                       you must remove the jira charting plugin jar to make the pending features work.

                      1. May 16

                        gabriel says:

                        Thank you for the reply. I have found success with the following: Running JIRA E...

                        Thank you for the reply. I have found success with the following:

                        Running JIRA Enterprise Edition, Version: 3.12.3-#302,

                         
                        Delete jira-charting-plugin-X.jar

                        Install jira-charting-plugin-pending-1.3.4.jar

                        Restart JIRA

                        Additional features will be available.

  14. May 25

    djankowski says:

    I tried on JIRA 3.12.3#302. After moving jirachartingpluginpending1.3.4.jar into...

    I tried on JIRA 3.12.3#302. After moving jira-charting-plugin-pending-1.3.4.jar into WEB-INF/lib I have features enabled.

    But after adding "Created, Resolved Issues and pending Stock" to a dashboard, there is a message on the dashboard "No chart created. Possibly invalid project or saved filter selected? ".

    In jira log there is an exception

    2008-05-25 22:27:25,328 http-8080-Processor25 WARN [velocity] org.apache.velocity.runtime.exception.ReferenceException: reference : template = templates/charting/createdvsresolvedpending.vm [line 8,column 191] : $versionLabels is not a valid reference. (by the way I am not using version field in this installation, it was 'hidden" in Field Configuration)