Hi I am fairly new to eazyBI, had used another BI tool before, still trying to understand grasp the concepts better. I am trying create a calculated measure to get the story points that are done( defined as development done, SIT done, UAT done) within a particular sprint duration for a velocity chart. Problem is when I create a report, there could be cases where the story points are completed outside of that sprint dates but still recorded within that sprint number. Does that make any sense?
Hi, @bhtan
Welcom to the eazyBI community.
To count the story points resolved that are done within a particular sprint duration, please consider using the function DateMembersBetween: DateMembersBetween
As for the date interval in this function, use Sprint Start Date and Sprint End Date and count the story points resolved (ignoring the Sprint). The formula should look something like this:
Sum(
[Time].[Day].DateMembersBetween(
[Measures].[Sprint start date],
[Measures].[Sprint end date]
),
([Measures].[Story Points resolved],
[Sprint].CurrentHierarchy.DefaultMember)
)
Please choose the Formatting - Decimal:
Please check our DEMO account reports: Sprint velocity chart - Issues - Jira Demo - eazyBI
Kindly,
Ilze support@eazybi.com