Calculating the Percentage of Issues Closed In 2 Days as a part of All Issues in a Period

[Kieron L. Jones]

Hi there,

I am trying to calculate a percentage of issues closed in 2 days as part of all issues in a period.

a) I have a JQL that will allow for a count of issues resolved in 2 days

b) I have a JQL that will allow for a count of issues raised in 6 months

I need to be able to divide a) by b) and * 100

to get the % of issues closed in 2 days.

Can this be done in a gadget or in a JQL? I have yet to find a way.

I have Custom Charts by Old Street and Script Runner by Adaptive installed,  but that's all. 

Other gadgets are standard.

Thanks in advance,

Kieron

[Danut M _StonikByte_ · Accepted solution]

Hi @Kieron L. Jones, 

You can easily do this with our Great Gadgets app. One of the many gadgets that it offers is the Advanced Issue Filter Formula gadget that allows applying math formulas on custom filed from up to 6 filters and display up to 6 results. Here is an example:

This app offers many other gadgets that you will find useful.

If you have questions, please don't hesitate to contact us at support@stonikbyte.com.

Thank you,

Danut M. 

[Ivan Lima]

Hi, @Kieron L. Jones. It appears that you have the necessary tools at your disposal. Although I haven't tested, it may be possible for you to craft distinct customized JQL segments within a two-dimensional bar chart and analyze the ratios of said segments. Please refer to Custom Charts Display Option: Calculate percentages of segments out of a single Bar, Row, or Line total.

[Kieron L. Jones]

Thank you @Ivan Lima .

I have already tried creating a 2D bar chart, but the %age is only calculated as part of a segment, such as priority. So where the bars are stacked by priority, the % age is 100%.

The %age is calculated as a whole of the bar, with sub-percentages being displayed on hover, all added up makes the total.

What we need, is a figure that is calculated as a %age of a whole data set, for example,

(Service Requests Completed < 2 Days) / Total Service Requests Raised in a Month) * 100

So if 50 SRs were created in MAY and 10 of them were completed in 2 days, the %age would be 20%.       There are 2 metrics involved.

[Ivan Lima]

Understood. I'm positive that ScriptRunner and Automation for Jira can help you with this calculation if you want to explore them, but you may need to store it somewhere, and I wonder if it will display how you expect it. I have done something similar and many more using eazyBI, so I know it's possible, and you can add that to the dashboards. Anyway, I'll make sure to poke around and see if anybody else can chime in here with more insights into this.

[Kieron L. Jones]

Thanks Ivan. We've come from a ServiceNow background, and their Performance Analytics module (read something like EaziBI) is a very function rich environment wit data collection and snapshots, which makes this type of thing available and easy to use.

It's unfortunate that we have to move to a product (and level) that is a little less function rich. It's causing all sorts of headaches!