How to create a report with bug issues that were fixed before and after there 'Resolve deadline'

[Daniël]

Hi all,

So basically I need to report every week how many bug issues breached there 'Resolve deadline'  and how many were fixed before there 'Resolve deadline'.  

It would be great if I could display on a Jira dashboard in a chart and email this to my team. I already tried to do this by filtering on 'Resolution' and Resolve deadline'. But that didn't really work.

Hope someone can help me out.

Thanks!

[Janis Plume _eazyBI_]

Hi,

eazyBI for Jira add-on allows creating such reports. You can import your custom fields in eazyBI (like the Resolve deadline) and with the help of the custom calculations count the issues resolved before the deadline or after.

You may have a look on some reports in the eazyBI Demo account here:

https://eazybi.com/accounts/1000/dashboards/4553-jira-issues-dashboard

You are welcome to start your trial and contact support if any assistance is needed.

Kindly,
Janis, eazyBI support

[Jack Brickey]

Unfortunately date compare in JSW is lacking. :-(

I would consider an addon approach. You could look at Scriptrunner, powerscripts or possibly Automation for Jira Lite (free). I would look to mimic SLAs in JSD by creating a field called say SLA and every time an issue transitions to done/closed then compare the now-date to the due date and set the SLA field to met/breached. Also, consider the reopen transition to see what you would like to do there, i.e. clear SLA or leave set. 

Note, there are other thoughts on this already posted in the Community. With a bit of searching ("compare dates", "jql resolved date vs. due date", etc.). You may find other ideas and even solutions associated w/ specific addons like SR. Here is an old thread but there are many others I expect.

[Daniël]

@Jack Brickey thank you! I will try scriptrunner :)

[Lennart]

Hey @Daniël - i think you won't be able to do this by JIRAs built-in JQL. This is where JQL functions (Scriptrunner) come in handy: https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_datecompare

[Daniël]

@informatikus thanks for your reply! Okay but when I use scriptrunner and have filtered all tickets. How can I show them all in a chart?

[Lennart]

You're most welcome.

In case you'd like to show this informations on your issues you could have scripted fields for registering your SLA stats (scored / missed) and should be able to select this field as Statistic Type within the "Pie Chart" Gadget.

Furthermore you could build one filter (comparing 'Resolve deadline' to the current date) and build a Pie-Chart using "Status" for the Statistic Type.

There might be more ways to do this (and probably better ones) but these are the ones i could currently think of. For reporting there are nearly endless ways most of the times. In my experience it's way easier using eazybi while your reporting needs grow. You can even combine ScriptRunner and eazybi. But this all depends on your needs and budget. Have Fun! :)

[Jack Brickey]

create a customer field called say SLA and simply set it to met/breached everytime an issue is closed. then a simple JQL will give you all the pretty pictures on dashboards you want. :-)