Chart status of tasks in sprint without including previously done subtasks

[Chris Norman]

I am finding it extremely annoying that when I graph the status of tasks in sprint without including previously done tasks and subtasks that I cannot exclude subtasks that were done in previous sprints.

I created a custom field using Script Runner called Orbit Start Date with the following groovy script:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def sprintCf = customFieldManager.getCustomFieldObjectByName("Sprint")
Issue issue = issue
issue.getCustomFieldValue(sprintCf)?.startDate?.first()?.toDate()

I have the template as Text Field (multiline) because that returns a date and if I set the template to Absolute Date Time it will display invalid date when displayed on an issue field and $datePickerFormatter.format($value) when I try to preview when editing the script field in scriptrunner.

When I try to use the custom field to try to get the issues that were resolved after the sprint began like this: 

issueFunction in dateCompare("","resolutionDate > Orbit Start Date")

I get this error:

• Field name: Orbit Start Date not found or not a date or datetime.
• Use a comparison like: "dueDate > resolutionDate", or "dueDate > resolutionDate + 2w", or "My Date Custom Field > My Other Date Custom Field"

Any advice or a different way to do this would be greatly appreciated. Thanks!