# Display issue created only within a sprint

**URL:** <https://community.eazybi.com/t/display-issue-created-only-within-a-sprint/3648>\
**Category:** Questions & Answers\
**Created:** [February 5, 2020, 10:51am UTC](https://community.eazybi.com/t/display-issue-created-only-within-a-sprint/3648 "2020-02-05T10:51:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlanG](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/22d042/32.png) [@AlanG](https://community.eazybi.com/u/AlanG)\
**Post date:** [February 5, 2020, 10:51am UTC](https://community.eazybi.com/t/display-issue-created-only-within-a-sprint/3648/1 "2020-02-05T10:51:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![daina.tupule](https://community.eazybi.com/user_avatar/community.eazybi.com/daina.tupule/32/8838_2.png) [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\
**Post date:** [February 28, 2020, 9:06am UTC](https://community.eazybi.com/t/display-issue-created-only-within-a-sprint/3648/2 "2020-02-28T09:06:36Z")

</div>

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](mailto:support@eazybi.com)