I would like to create a dashboard widget that shows items resolved last year vs. this year

[Sherri Anderson]

I am trying to create a filter in JIRA that I can use to create a pie chart.  I would like to show number of initiatives and epics resolved this year vs. number or initiatives and epics resolved last year.  I am not having much luck, can anyone please assist?

[Michael Kuhl {Appfire} · Accepted solution]

Hi Sherri - Try this JQL:

Resolved Last Year:

issuetype in (Initiative,Epic) and resolved >= startofyear("-1") and resolved <= endofyear("-1")

 Resolved this year:

issuetype in (Initiative,Epic) and resolved >= startofyear() and resolved <= endofyear()

[Ethan Cook]

With Jira built in reports, you won't be able to make the specific chart that you want to. If you used a plugin, such as eaziBI, you should be able to make this specific pie chart. This will take a bit of knowledge on how to use eazyBI, and the plugin isn't free, but that's an option. You can even export the chart from eazyBI onto your Jira dashboard.

If you don't need the chart to be automated, and you don't necessarily need it on your Jira dashboard, you could always make it manually in Excel. You could use the JQL queries that Michael wrote above and see how many results pop up for each, and then use those two numbers to make a pie chart in excel.

I hope this is helpful!

[Sherri Anderson]

That is beautiful, thank you!!!  Now I just have to figure out how to make a pie chart with two searches lol