Sprint Actual Start and Actual End Dates

Questions & Answers
1

I’m utilizing the following calculated member in a Sprint dimension to filter (pages) Sprints based on Sprint name prefix:

Aggregate(
  Order(
    Filter([Sprint].[Sprint].Members,
      [Sprint].CurrentMember.getBoolean('Closed') AND
      NOT IsEmpty([Sprint].CurrentMember.get('Complete date')) AND
            [Sprint].CurrentMember.Name MATCHES '^(?i)ACME\s+Sprint\s+9\s*\-.*'         
        ),
    [Sprint].CurrentMember.get('Complete date'),
    BASC
  )
)

There is no problem with the filtered results. The problem is that the resulting Sprints are based on planned start and end dates and I need actual Sprint start and end dates. I’m displaying the dates (Sprint days) across the X-axis in Sprint burn-up/burn-down charts.

What code do I need to add to the above to override the default planned Sprint start/end dates with the actual Sprint start/end dates?

2

Hi @AWPPMT,
You are already using an actual Sprint end date in your formula.
In eazyBI, you can retrieve both of those dates; see the documentation on Jira Software custom fields.
The planned end date is “Sprint end date” or formula: [Sprint].CurrentHierarchyMember.get('End date')
While “Sprint actual end date” formula is: [Sprint].CurrentHierarchyMember.get('Complete date')

best,
Gerda // support@eazyBI.com