nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Michael Kuhl {Appfire}

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()

All comments

Michael Kuhl {Appfire}

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()

Sherri Anderson

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

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

filter

dashboard

widget