Display issue created only within a sprint

Questions & Answers
1

Hi,

I am new to EazyBI and I would like to create a report that displays only issues (bugs) that were created during the sprint (active sprint) and filter out issues that were moved from sprint to sprint.
I tried experimenting a bit but had no success.

Thanks

2

You would like to use a measure representing current Sprint. In this case, I would suggest using a measure Issues created as you would like to validate issue creation time as well.

You can use Sprint start sate and Sprint end date to retrieve Time periods where issues should be created:

CASE WHEN 
[Sprint].CurrentMember.Level.Name = "Sprint"
THEN
SUM(
  {
  [Time].CurrentHierarchy.Levels("Day").DateMember([Measures].[Sprint start date]):
  [Time].CurrentHierarchy.Levels("Day").DateMember([Measures].[Sprint end date])
  },
  ([Measures].[Issues created],
   [Issue Type].[Bug])
)
END

The formula above, pulls in date period to represent sprint active period. Measure Issues created will work as a validation an issue was not removed from a sprint and was resolved in the sprint till the sprint completion time. It also will pull in issues created in dates representing the sprint period.

Daina / support@eazybi.com