Aggregating sprint data over multiple sprints in different projects

Questions & Answers
1

I have an account that has data from multiple projects. The projects have sprint names like “ASJ PI 24-3”, “MDM PI 24-3” or “OIVA PI 24-3”. I have created a report that shows the sprint issues committed, sprint issues completed of committed and a custom measure of sprint issues completed of committed % and the report also has a filter to show only last 5 closed sprints on the report.

What I would like to achieve is the ability to aggregate the sprint issues committed, completed and completed of committed % across the different sprints to get one number for each “generic” sprint (PI 24-3, PI 24-2 etc).

I tried this by creating a custom field in the account that creates a field “LT PI” and it uses pattern matching to create the field values like “PI 24-3, PI 24-2” and that is imported as a property and dimension. It works fine when looking at measure like issues created, but not with the sprint issues measures, which I guess is understandable the way it is currently defined.

Is there even a way to achieve what I need?

So the report would look like something like this but aggregated across multiple projects / sprints:

image
image839×349 29.5 KB

2

Hi vpurho,
Thanks for reaching out to the eazyBI community!

It sounds like you’ve created a new custom field and imported it as both a property and a dimension, which is why it’s currently mapped to standard issue measures rather than sprint measures.

To achieve the desired result, rather than creating a new dimension, you’ll need to add a property to the Sprint dimension using the REST API as the data source. Then, create a new custom hierarchy within the Sprint dimension.

Here’s how:

  1. Import Additional Property: Follow this example: Combining Different Teams’ Sprints and adjust the custom JavaScript to fit your naming requirements.
    For further guidance, I also recommend this training video section, especially the “Power-Up Reports with Additional Data Import”: Training Videos on Data Mapping.

  2. Import Data and Create Custom Hierarchy: After importing the data, follow these steps to set up the new hierarchy in the Sprint dimension: Custom Hierarchies in eazyBI.

Let me know if that works for you or if you have any additional questions or encounter any issues with import.

Kindly,
Ilze