HI Team,
I have a requirement that needs to count the sprint duration. If the sprint duration is 1 week how many sprints we have with duration one week.
If the sprint duration is 2 weeks how many sprints have duration with 2 weeks.
Can anyone help here?
Hi,
We already discussed this question directly in support emails. There is a short summary.
I can imagine two options for how to get the information in a report.
- You may create a measure (in Measures) that returns the length of a sprint. Use this measure in columns and Sprint dimension sprints in rows; order/filter the sprint list by this measure.
The length of each sprint is calculated in the following way:
DateDiffDays(
[Measures].[Sprint start date],
[Measures].[Sprint end date]
)
- Another option is creating a separate measure for each sprint duration to count how many sprints have this particular length.
To get the count of sprints with, let’s say, duration 1 week or less, you may create a measure to count them:
Count(
Filter(Descendants([Sprint].CurrentHierarchyMember, [Sprint].[Sprint]),
DateDiffDays(
[Measures].[Sprint start date],
[Measures].[Sprint end date]
)<=7)
)
Create separate measures and combine filter conditions for other durations.
Note that there are used planned sprint start and end dates; you may use sprint actual start and end dates instead (then use other sprint properties in the formula)
Best,
Ilze / support@eazybi.com