Stories planned sprint for Epics in Project

Questions & Answers
1

I’d appreciate any help in getting this issue sorted out.

My setup:
I have a Dimension called Maturity with values of Draft, Review and Final. It is applied to my Stories.

I am trying to create the following table:
Rows represent Epics in my project.
Columns are the Maturity dimension above, and in the cross section, the End date of the Sprint they are assigned to.

The expected result is an Epic row, with dates of when the Stories of the different Maturity will be ready.
Please advise if there is a way to do this.

2

Hi @shaishap ,

Welcome to the eazyBI community.

One approach is to look through not completed Sprints the Stories are in and retrieve the latest Sprint end date. For example, the formula for such a calculated measure could look similar to the one below:

TimestampToDate(
  Max(
    Filter(
      Descendants([Sprint].CurrentMember,[Sprint].[Sprint]),
      Not IsEmpty([Sprint].CurrentHierarchyMember.Get('End date'))
      AND
      [Measures].[Sprint closed?] = 'No'
      AND
      [Measures].[Issues created] > 0
    ),
    DateToTimestamp(
      [Sprint].CurrentHierarchyMember.Get('End date')
    )
  )
)

The report then could look similar to the one below:

Screenshot 2022-07-20 at 15.32.07
Screenshot 2022-07-20 at 15.32.071700×636 65.5 KB

See more details on the eazyBI documentation page about the functions used in the calculation - MDX function reference.

Best,
Roberts // support@eazybi.com