Average Story Points for Tickets (Story or Tasks) Closed in the past 3 Sprints

Hi all,
I’m new to EazyBI, so trying to build my first dashboard. :slight_smile:

I’m trying to calculate what the average Story Point is for all stories and tasks that were closed in the past 3 Sprints. This should only include stories and tasks were Story Point > 0. Any ideas on how to do that?

Any help is appreciated.

Thank you!

Hi @edelamarta!

By default eazyBI creates a measure for Running velocity for 5 closed sprints, you can see this measure in a demo report here: https://eazybi.com/accounts/1000/cubes/Issues/reports/61946-sprint-velocity-chart.

Based on this measure you can create a new measure for the last 3 sprints by modifying the Tail(...) from 5 to 3.

Lauma / support@eazybi.com