# Individual Developer Velocity - Last 4 Sprints

**URL:** <https://community.eazybi.com/t/individual-developer-velocity-last-4-sprints/10542>\
**Category:** Questions & Answers\
**Created:** [September 13, 2022, 9:11pm UTC](https://community.eazybi.com/t/individual-developer-velocity-last-4-sprints/10542 "2022-09-13T21:11:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![laboyd001](https://community.eazybi.com/user_avatar/community.eazybi.com/laboyd001/32/7912_2.png) [@laboyd001](https://community.eazybi.com/u/laboyd001)\
**Post date:** [September 13, 2022, 9:11pm UTC](https://community.eazybi.com/t/individual-developer-velocity-last-4-sprints/10542/1 "2022-09-13T21:11:30Z")

</div>

Hello!

I’m new to easyBI. I need some help creating a report that I’ve been constructing manually in google sheets.

I’m trying to display the story points completed by developer per sprint in the last 4 sprints. Each sprint is a column. I’m also wanting to display average velocity for those 4 sprints by developer in a separate column.

I’ve figured out how to show completed story points by developer, but not sure how to automatically filter to the last 4 sprints being displayed. Also, I haven’t figured out how to calculate the avg sprint velocity per developer.

Here’s the google sheet:

 ![google_sheet](https://community.eazybi.com/uploads/default/original/2X/2/212d27f8f43c0b7edba83fd151bc01845fcb681e.png)

avg velocity = =sum(B2,C2,D2, E2)/4

---

<div class="post-metadata">

**Author:** ![laboyd001](https://community.eazybi.com/user_avatar/community.eazybi.com/laboyd001/32/7912_2.png) [@laboyd001](https://community.eazybi.com/u/laboyd001)\
**Post date:** [September 13, 2022, 9:12pm UTC](https://community.eazybi.com/t/individual-developer-velocity-last-4-sprints/10542/2 "2022-09-13T21:12:25Z")

</div>

Here’s easyBI so far:

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

I manually removed sprint older than the last 4.