Display issue created only within a sprint


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.


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:

[Sprint].CurrentMember.Level.Name = "Sprint"
  [Time].CurrentHierarchy.Levels("Day").DateMember([Measures].[Sprint start date]):
  [Time].CurrentHierarchy.Levels("Day").DateMember([Measures].[Sprint end date])
  ([Measures].[Issues created],
   [Issue Type].[Bug])

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