Roadmap - Initial Sprint Start Date

Questions & Answers
,
1

Hello,

I am creating a report using the Advanced Roadmap hierarchy. I came across a situation like this, but I couldn’t solve it. Can you help with this.

For example, a Story could not be completed in Sprint-1 and continues in Sprint-2. With the query below, I only get the start date of the active sprint (sprint-2) as the start date of this story, but the date that I actually want to get is also related to the sprint-1.

image
image1437×356 41.3 KB

image
image1759×480 48.1 KB 

Order(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentHierarchyMember.Name <> "(no sprint)" AND
    ([Measures].[Issues created],
    [Time].CurrentHierarchy.DefaultMember) > 0
  ),
  [Measures].[Sprint start date], 
  BASC
).item(0).get('Start date')```
2

@sefa.gerdan

Measure “Issues created” that you use as context in your custom calculation ties the issue to the latest sprint.
See more on sprint scope measures here: Jira Software custom fields

In your case, you could try using a different formula.

Order(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentHierarchyMember.Name <> "(no sprint)" AND
    (
    ([Measures].[Sprint issues committed],
    [Time].CurrentHierarchy.DefaultMember) 
    +
    ([Measures].[Sprint issues added],
    [Time].CurrentHierarchy.DefaultMember) 
    ) > 0
  ),
  [Measures].[Sprint start date], 
  BASC
).item(0).get('Start date')

Martins / eazyBI