Hi!
I need to do a productivity calculation and this involves the issue time spent and issue remain estimate in a reference date (this date is a custom field).
I am using Misc Custom Fields to create a calculated number field in issue.
I got a help here to get formula and sum of worklogs to date. And it worked.
<!-- @@Formula:
import com.atlassian.jira.component.ComponentAccessor;
if (issue.get("timespent") == null) return;
customDate = issue.get("customfield_10300");
if (customDate == null) return;
hours = 0.0;
worklogManager = ComponentAccessor.getWorklogManager();
for (worklog : worklogManager.getByIssue(issueObject)) {
if (worklog.getStartDate().getTime() <= customDate.getTime()) {
hours += worklog.getTimeSpent() / 3600.0;
}
}
if (hours > 0) {
return hours;
}
-->
Now I'm having difficulty writing the calculation that gets the remaining estimate in this date.
I got a tip from EazyBI team to get the last remaining estimate before this date from issue changelog, but i don't know how to do this.
Could anyone help me?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.