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:
I have selected the sprint dimensions.
I have broken down the sprints by board level to separate each team’s sprints.
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.
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