The Two Dimensional Filter Statistics gadget allows a nice summary presentation of the current state of a project. What is also needed is a graph widget that shows the work remaining for a project. This can be shown nicely with a graph that has a jira count on the y-axis and the date on the x-axis. The the only thing left is for the user/admin to choose what filter to use for each line, e.g. a simple two line chart would show open jiras for ProjectA, and resolved jiras for ProjectA.
Is there such a gadget, or a way to bend an existing gadget to get 90% of the information shown in a graph?
I'm not sure if I understood you correctly, but if you are trying to get a report of issues created vs. issues resolved over time to see how much work is left, you can possibly use one of the following reports in JIRA:
I hope this helps!
Neither "Created vs Resolved" nor "Recently Created" helps.
Using the Rick's data example above ...
If my product has only be worked on for 10 weeks, then yes, what I want to see is 3, 7, 10, 11, 11, 10, 7, 4, 0 and that is done by the "Created vs Resolved" report.
But what if my product has been around for 3 years? 10 weeks ago there could have been a hundred of bugs, so what I really want to see is
103, 107, 110, 111, 111, 110, 107, 104, 100
You may say that I could still use the "Created vs Resolved" report only create it for the whole lifecycle. True, only
1) I will have to adjust the query as time goes
2) I am really only interested in past 10 weeks
The Created vs Resolved Show Unresolved Trend should show this but it doesn't. Instead of calculating how many bugs are actually open on a given day, as I understand it, it arbitrarily assumes that the number of defects is zero at the beginning of the period. Thus, it can tell you that, in the last 42 days, you've resolved 17 more than you've opened, but not how many are actually open !
This is a critically useful piece of information, and as Rick says, this is trivial in Excel. Atlassian, please help !
As a simple example; imagine a 10 week long project where you have to fix, verify and close all jiras reported against that project.
The weekly found count might look like this: 3, 4, 5, 5, 6, 4, 2, 1, 0, 0
The weekly fixed cound might look like this: 0, 0, 2, 4, 6, 5, 5, 4, 4, 0
The weekly closed count could look like this: 0, 0, 0, 0, 5, 5, 5, 5, 5, 5
This gives the (not yet fixed) count of: 3, 7, 10, 11, 11, 10, 7, 4, 0, 0 I want a line graph of this data. It shows a running count of how many bugs need to be fixed.
This gives the (not closed) count of: 3, 7, 12, 17, 18, 17, 14, 10, 5, 0 I want a line graph of this data. It should how many bugs need to be verified and closed.
The project can not ship until the all the found bugs are fixed (the not yet fixed count = 0) and all the bugs have been verified and closed (the not closed count = 0)
This is trivial to do in Excel.
Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events