Data comparison report

[Deepthi S]

Can you please suggest which report I can use for comparing data between years?

[Nic Brough -Adaptavist- · Accepted solution]

Any that can take a date range as part of their parameters (usually done by the filter more than the report)

If you want more than that, I'm afraid your question is too vague as it is.  What are you trying to compare?  What are you hoping the report will tell you?

[Deepthi S]

I m trying to compare bugs based on severity between years  i.e from 2018 , 2019 and 2020

I used issue by date report. But its summing up the values for every year. 

For example, 2018 : 10 critical issues

2019 : 12 critical issue and 2020 18 critical issues

Then report display following date on chart i.e

2018 :10, 2019 :22 and 2020 : 40

So I was searching some other reports which I can use to display this information

[Nic Brough -Adaptavist-]

I can think of two ways to do this without leaving Jira, although one requires a little code.

The native way with no code needed:

• Create filters for
  • Created => startOfYear(-2y) and Created < endOfYear(-2y)
  • Created => startOfYear(-1y) and Created < endOfYear(-1y)
  • Created => startOfYear() and Created < endOfYear()
• Then create a dashboard with three gadgets on it - one for each filter.  Select the field "severity" for the "group by" and you should find you have a dashboard that shows you all issues by year and severity
• Downside:  You'll need a new filter and gadget every year, and it's not really the most informative of charts.

The option with some coding:

• Create a field for "Year", ideally a select list. 
• Use some code that can look at an issue's created data, pull out the year and set it in the select list
• Create a dashboard and add a 2-dimensional gadget, using severity and year as the axes
• Downsides: coding and even less graphical than the first solution.
• Upside: the use of a select list for the year gives you a lot more flexibility - there's quite a few other gadgets that may be worth a look