Median time for issues from added into Sprint

Questions & Answers
1

Hi all!
I am trying to create a report, for Sprints, and I am not able to read the date when an Issue was added to its First Sprint (in the case it was a Spillover).

Can you help me on this?

I tried to use the tripla:

TimestampToDate(
( [Measures].[Transition to first timestamp],
  [Transition Field].[Sprint status],
  [Sprint Status].[Closed],
  -- An issue was added or created in an active sprint
  [Issue Sprint Status Change].[(none) => Active]
))

But it returns null

That is because if the issue is a spillover, then it is completed in the following Sprint and

[Issue].CurrentHierarchyMember.get(‘Sprint Incoming State’) = ‘Committed’
So, it is not the correct date.

I can read the Sprints through the Property:

[Sprint].[Sprint].GetMembersByKeys(
   [Issue].CurrentHierarchyMember.Get('Sprint IDs')).Item(0)

Really appreciated

2

Hi Nacho

I would suggest looking for the issue’s very first transition to any of the sprints (regardless of the sprint selection in the report), without checking the sprint status at that moment:

TimestampToDate(
([Measures].[Transition to first timestamp],
[Transition Field].[Sprint],
[Sprint].CurrentHierarchy.DefaultMember
))

Let me know if it works for you; if not, please, add more information what is selected in the report (a screenshot with visible dimensions in Rows and Pages would be enough).

Best,
IlzeLA , support@eazybi.com

3

Hi ilze! Thanks for your answer.

However, it is not working I tried that in several ways and none of them are returning something. (column is not displayed)

You can see below what is in the report (for debugging options I have selected the Issue dimension although it will be out of the report), so the idea is it have only the Percentile formula at columns and for rows Team & Time.

“Issue Added or Committed” is an IIF checking the “Sprint Incoming State”
I tried with your hole tuple or commenting the Sprint dimension and same case.

image
image1746×897 139 KB