This question is in reference to Atlassian Documentation: Configuring Estimation and Tracking
Is it possible to calculate the total estimated work and the total logged work for an epic containing issues which have sub-issues?
Yes.... Let me dig out a script
Using Scriptrunner
CustomField = EPIC Total Time Spent which shows on an EPIC the total time spent across linked issues (Stories & subtasks)
{code:groovy}
import com.atlassian.jira.ComponentManager
import java.text.DecimalFormat
def componentManager = ComponentManager.getInstance()
def issueLinkManager = componentManager.getIssueLinkManager()
def totalTimeSpent = 0.0d
def epicTimeSpent = issue.timeSpent
if(epicTimeSpent) {
totalTimeSpent += epicTimeSpent
}
if(issue.getSubTaskObjects() != []) {
issue.getSubTaskObjects().each {epicSubTask ->
def epicSubTaskTimeSpent = epicSubTask.timeSpent
if(epicSubTaskTimeSpent) {
totalTimeSpent += epicSubTaskTimeSpent
}
}
}
if(issueLinkManager.getOutwardLinks(issue.id) != []) {
issueLinkManager.getOutwardLinks(issue.id).each {issueLink ->
if (issueLink.issueLinkType.name == "Epic-Story Link") {
def linkedIssue = issueLink.destinationObject
def linkedIssueTimeSpent = linkedIssue.timeSpent
if(linkedIssueTimeSpent) {
totalTimeSpent += linkedIssueTimeSpent
}
//if(linkedIssue.getSubTaskObjects().size > 0) {
if(linkedIssue.getSubTaskObjects() != []) {
linkedIssue.getSubTaskObjects().each {linkedIssueSubTask ->
def linkedIssueSubTaskTimeSpent = linkedIssueSubTask.timeSpent
if(linkedIssueSubTaskTimeSpent) {
totalTimeSpent += linkedIssueSubTaskTimeSpent
}
}
}
}
}
}
if(totalTimeSpent > 0) {
totalTimeSpent = totalTimeSpent / 60.0d / 60.0d / 8.0d //Seconds to Hours
}
//formatNumber(number: totalTimeSpent, Locale.ENGLISH, format: '##0.0')
//new DecimalFormat("#.#").format(totalTimeSpent);
totalTimeSpent
{code}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just amend it for Total Estimation of time...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your quick reply. I will have a go, after installing the script runner which we do not have.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, you can use BigGantt plugin for to getting total time and work...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Epic SumUp can do this. You cannot do this natively out of the box.
https://marketplace.atlassian.com/plugins/aptis.plugins.epicSumUp/cloud/overview
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.