Aggregate Sprint By Name

Hi @Gisela_Nogueira,

You can add custom hierarchy that would group sprints by matching string or numeric properties (sprints with the same property value are grouped) in Sprint dimension.

  1. First, you might want to import criteria for grouping sprints as a property using additional data import: Additional data import into Jira Issues cube.
    For example, import planned start period as string, program increment, or some other attribute indicates which sprints should be grouped.

  2. Then, in Sprint dimension, chose to add a custom hierarchy: Create reports.

And here is a training video on additional data import and how to build a custom hierarchy from those data:
Screenshot 2021-05-10 at 17.06.36
Presentation slides: Power-up-reports-with-additional-data-import.pdf (5.9 MB)

Please see this community post on a similar use case and solution how to import Sprint properties from REST API:

Best,
Zane / support@eazyBI.com