Can I calculate a percentage of (total time under specific status) based on specific calendar

Aya AlJboor

I would like to find a plugin that would give the ability to generate the following:

1. Calculate the time taken from creating the issue until resolution (as total downtime) for each issue.
2. A report to Calculate the total downtime in minutes, the summation is grouped by a field in the issue-level
3. a percentage of downtime per month based on the following formula: downtime (calculated in point 2)/(24*60*30)

 

I found a plugin that could do the first two points but facing some issues in the last point!

Oday Rafeh_2jhprw

Hi @Aya AlJboor 

You can use a combination of Jira built-in features and plugins. I'll suggest a solution for the third point using ScriptRunner for Jira.

Please use this script in your script field: 

import com.atlassian.jira.component.ComponentAccessor

def issueManager = ComponentAccessor.getIssueManager()

// Retrieve the custom field holding downtime in minutes
def downtimeField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("Downtime in Minutes")
def downtimeInMinutes = issue.getCustomFieldValue(downtimeField) as Double

if (downtimeInMinutes == null) {
return null
}

// Calculate downtime percentage based on the formula provided
double totalTimeInMonth = 24 * 60 * 7 * 30
double downtimePercentage = (downtimeInMinutes / totalTimeInMonth) * 100

return downtimePercentage