Sprint Goals for Current Sprints

Questions & Answers
1

I am new to EazyBI and having a hard time wrapping my head around the measures and dimensions work. I would like to get a report that show the current sprint goal for each of the projects going on in my company. I can’t seem to get this to show up correctly. Could you give some guidance about how to go about this?

Also, if I wanted to get the current sprint goal plus the goals for the previous two sprints, how would I do this?

2

Hi,

The hard part of this use case is to find the “active sprint of the project.” There are no direct relationships between these dimensions, and we need to find the project-related sprint using the measure. The idea is to filter the Sprint members having an issue from the selected project.

Assuming that report contains the Project dimension, the following formula gives the set of all active sprints of the selected project:

Filter(
  [Sprint].[Sprint].Members,
  [Measures].[Issues created]>0
  AND
      NOT [Sprint].CurrentMember.getBoolean('Closed')
      AND
      NOT isEmpty([Sprint].CurrentMember.get('Start date'))
)

If we can assume there is only one active sprint per project, we can take the first element of this set and then extract the sprint goal:

Filter(
  [Sprint].[Sprint].Members,
  [Measures].[Issues created]>0
  AND
      NOT [Sprint].CurrentMember.getBoolean('Closed')
      AND
      NOT isEmpty([Sprint].CurrentMember.get('Start date'))
).Item(0).Get('Goal')

My report could look like this:

image
image1566×758 92 KB

Finding the earlier sprint could be implemented by adding the Prevmember:

Filter(
  [Sprint].[Sprint].Members,
  [Measures].[Issues created]>0
  AND
      NOT [Sprint].CurrentMember.getBoolean('Closed')
      AND
      NOT isEmpty([Sprint].CurrentMember.get('Start date'))
).Item(0).PrevMember.Get('Goal')

Kindly,
Janis, eazyBI support