Show JIRAs closed by quarter

[Jeremy Miller]

I would like to find out how to create a dashboard gadget to display how many JIRAs were completed each quarter. 

This query shows for a whole year but I would like a bar graph splitting this up into quarters if possible.

status = Closed AND assignee in (currentUser()) AND resolved >= 2016-01-01 AND resolved <= "2016-12-31 23:59" AND NOT resolution = Unresolved ORDER BY resolved DESC

For bonus points we have a field called CR, if there is data in this field I would like to add that to the number of the count.

Similar to this graph: https://upload.wikimedia.org/wikipedia/en/e/ea/Passenger_numbers_for_London_Airports_in_a_bar_graph.png

So it will show JIRAs and CR's completed and split that into quarters. If this is possible great if not at least the JIRA's I think would be.

[darrenpegg · Accepted solution]

Just a guess...

Try status = Closed AND assignee in (currentUser()) AND resolved >= 2016-01-01 AND resolved <= "2016-12-31 23:59" AND NOT resolution = Unresolved and <customfield> is not EMPTY ORDER BY resolved DESC

and use the Average Age Chart Gadget (ignoring it mentions Average Age) I get the same values regadless of what the chart says it is for..

1. Period Quartley
2. Days = 365 (even though the query is stating this anyway)

However as Doug mentions... Dataplane and or PowerReport should and offer you lots more.. or try this free one and have 4 gadgets.. https://marketplace.atlassian.com/plugins/com.tngtech.gadgets.jira-barchart-gadget-plugin/server/overview

[Jeremy Miller]

Thanks, I think this will be the best I am going to get. I am just a JIRA user and cannot add plugins. I was able to create two graphs using your help.

Thanks again.

[darrenpegg]

no problem

[Doug Swartz]

I don't know how to do this in native JIRA without a plugin.

The Dataplane plugin will let you do this. 

[Jeremy Miller]

That plugin looks amazing, I am only a user though and cannot add these.

Thanks for the help