Individual Developer Velocity - Last 4 Sprints


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:

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

Here’s easyBI so far:

I manually removed sprint older than the last 4.