Display Last sprint, Last 5 sprint, Last 7 sprint as rows

[Nada]

Hey guys,

I am working on creating a report in eazyBI where I need to aggregate the last N sprints (last sprint, last 3 sprints, last 5 sprints, and last 7 sprints) for each team and be able to drill down into the individual sprints within those groups.
Here’s what I have done so far:

1. I have selected the sprint dimensions.
2. I have broken down the sprints by board level to separate each team’s sprints.
3. I have drilled into each board by the sprint level.

As shown in the attached screenshots, I have managed to organize each team separately. However, now I need to group the sprints dynamically for each team and aggregate the data accordingly.

[Nada]

[janis.plume]

Hi,

The following formula is for finding last 3 sprints from all boards:

Aggregate(
Tail(
Order(
Filter(
[Sprint].[Sprint].Members,
[Sprint].CurrentMember.GetBoolean('Closed')
),
[Sprint].CurrentMember.Get('Complete date'),
BASC
)
,
3
)
)

This formula is for the aggregated member in the sprint dimension, but it will not dynamically adjust to other page filters used in the report.

If your report needs to adjust to the last N sprints from other page selections, the same logic must be transferred to each measure.

Kindly,
Janis, eazyBI support

[Nada]

how can i apply this formula, what the report structure should be ? the main goal of my report is to calculate the avg cycle time for (last 3 sprint, … etc) per issue type

Many thanks !