# Display a specific number of sprints

**URL:** <https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696>\
**Category:** Questions & Answers\
**Tags:** jira\
**Created:** [August 26, 2021, 3:40pm UTC](https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696 "2021-08-26T15:40:32Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![JPerez](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/e47c2d/32.png) [@JPerez](https://community.eazybi.com/u/JPerez)\
**Post date:** [August 26, 2021, 3:40pm UTC](https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696/1 "2021-08-26T15:40:32Z")

</div>

Hi, I have been using eazyBI for a short time and I have this question that I think is simple:

I have projects with many sprints and I need to be able to visualize in a report the last 5 completed sprints.

 ![image](https://community.eazybi.com/uploads/default/original/2X/4/4f061ec9de39f42330823f3b27529a1ffd2fe533.png)

In addition to this could I enter an input to get the last X sprint I want? Or would it be necessary to modify the measurement query each time I want to visualize a different number of sprints.

Thank you very much

---

<div class="post-metadata">

**Author:** ![eli\_solutions](https://community.eazybi.com/user_avatar/community.eazybi.com/eli_solutions/32/4822_2.png) [@eli\_solutions](https://community.eazybi.com/u/eli_solutions)\
**Post date:** [August 26, 2021, 10:20pm UTC](https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696/2 "2021-08-26T22:20:19Z")

</div>

Hi @JPerez,

You will have to use the Sprint Dimension as a Page:

 ![image](https://community.eazybi.com/uploads/default/original/2X/2/245a884294d4fff68cc91b1868f76b9702c7a194.png)

In this example we use the Current and Last PI which is 26 weeks, but for 5 closed sprints you will use 10 weeks if it’s a biweekly sprint.

Measure for the Sprint Filter.

```auto
Aggregate(
  Filter([Sprint].[Sprint].Members,
    NOT IsEmpty([Sprint].CurrentMember.get('Start date')) AND 
    DateBetween(
      [Sprint].CurrentMember.get('End date'),
      '26 weeks ago',
      'Now')
    
))

```

I hope this helps.

[Eli Solutions](https://www.youtube.com/channel/UCNpoN5CO_xVHjHLMaU4h02w)

---

<div class="post-metadata">

**Author:** ![JPerez](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/e47c2d/32.png) [@JPerez](https://community.eazybi.com/u/JPerez)\
**Post date:** [August 27, 2021, 10:15am UTC](https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696/3 "2021-08-27T10:15:49Z")

</div>

Thank you very much Eli, you have been a great help to me.

Now I only have one problem to solve and it is that if I want to choose two different sprints to compare them in the same report (using sprint as page). if I select them separately its okey but if I put them together, their values are added instead of showing them separately in the X axis. I show you one example.

Thanks in advance

 ![1](https://community.eazybi.com/uploads/default/original/2X/6/61a82e1e9dc4653d57898ec23cd46f9ee8b589d9.png)

---

<div class="post-metadata">

**Author:** ![JPerez](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/e47c2d/32.png) [@JPerez](https://community.eazybi.com/u/JPerez)\
**Post date:** [August 27, 2021, 10:16am UTC](https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696/4 "2021-08-27T10:16:30Z")

</div>

![2](https://community.eazybi.com/uploads/default/original/2X/f/f9f920cc8c3b901de9954b3c4f85cc27352597fd.png)

---

<div class="post-metadata">

**Author:** ![JPerez](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/e47c2d/32.png) [@JPerez](https://community.eazybi.com/u/JPerez)\
**Post date:** [August 27, 2021, 10:17am UTC](https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696/5 "2021-08-27T10:17:04Z")

</div>

![both](https://community.eazybi.com/uploads/default/original/2X/7/7791e4174ae616fd96c65ed664be87e3d7f8e91e.png)

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [September 2, 2021, 8:00am UTC](https://community.eazybi.com/t/display-a-specific-number-of-sprints/7696/6 "2021-09-02T08:00:03Z")

</div>

@JPerez

Please find related community post on how to filter the report for last 5 closed sprints:

> [@Filter your eazyBI for last 5 closed sprints](https://community.eazybi.com/t/filter-your-eazybi-for-last-5-closed-sprints/2099/4):
>
> So this is what I currently am working with. I have the correct sprints coming through, I just can not figure out how to order them chronologically by date. I am using this in the sprint member: Aggregate( Filter([Sprint].[Sprint].Members, NOT IsEmpty([Sprint].CurrentMember.get('Start date')) AND DateBetween( [Sprint].CurrentMember.get('End date'), '12 weeks ago', 'Now') AND ([Sprint].CurrentMember.Name MATCHES '^EPSS Sprint.\*' OR [Sprint].CurrentMember.Name…

And note the option to use the same dimension in columns and page filters.  
[https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions](https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions)

Martins / eazyBI support