Get remain estimate in a specific date

[Sergio Silva]

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?

[Sergio Silva]

Any Help?