Hi all,
I’m new to EazyBI, so trying to build my first dashboard.
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!
Erika
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