How to create chart to compare total issues of last year vs this year

[nayan_ff]

Hi,

I have a filter to view all issues of last year (Y2024) and another filter to view all of this year (Y2025). Is there any way to create a bar/graph to compare those to filter? I'm unable to find one so far. Please help.

Thanks,

Faruque

[Mohanraj Thangamuthu · Accepted solution]

Hello, Good day. You could create a filter query using following query and explore different gadgets in dashbpard.

created <= '2024-12-31' and created >= '2024-01-01'

[nayan_ff]

Thank you

[Danut M _StonikByte_ · Accepted solution]

Hi @nayan_ff,

A good solution is to use two Jira gadgets side-by-side, as mentioned already by @Jakub Cieslak.

But if want them in the same gadget or chart, you will need a plugin.

If you are willing to try a plugin, our Great Gadgets app offers multiple options for having these data in the same gadget or chart. 

One easy way is to use the Advanced Issue Filter Formula gadget and display the count of issues from each filter.

 Another good option is to use the Pivot Table & Pivot Chart gadget offered by the same app. This can display the data as a table, heat-map table or charts of various types.

Danut. 

[nayan_ff]

Thanks a lot,

This one is the perfect match for what I want.

Have a nice day.

[Jakub Cieslak · Accepted solution]

Probably the best approach is to create two filters and then use them as a source for graphs. 

You said you already have filters, but adding them here anyway, in case someone else is interested in this solution, too:

Filter #1 (CY2024): 

created <= '2024-12-31' and created >= '2024-01-01'

Filter #2 (CY2025):

created <= '2025-12-31' and created >= '2025-01-01'

And then, you could consider two graph types, Issue Statistics and/or Pie Chart. This could produce something like that:

Issue Statistics: 

Pie Chart:

You could also consider having a Jira Automation (e.g., manually triggered), that counts those two values via Lookup issues, then compare (or list) two corresponding {{lookupIssues.size}} smart values, and send you an e-mail or so. But this is probably going away too much from your initial idea of a Jira Dashboard.

I am not aware of any free graph/dashboard/plugin that would allow to compare those two values in one graphic.

[nayan_ff]

Thanks a lot.
Yes, this is the only way to "Freely" use my requirements