# Aggregate Sprint Names

**URL:** <https://community.eazybi.com/t/aggregate-sprint-names/3218>\
**Category:** Questions & Answers\
**Tags:** jira\
**Created:** [November 19, 2019, 6:39pm UTC](https://community.eazybi.com/t/aggregate-sprint-names/3218 "2019-11-19T18:39:44Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [November 4, 2021, 2:13pm UTC](https://community.eazybi.com/t/aggregate-sprint-names/3218/6 "2021-11-04T14:13:49Z")

</div>

Hi @Shel_Price ,

For my previous calculation to work for your naming pattern, this would be the formula for “Sprint 13” (the same should be repeated for the next sprints):

```auto
Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name MATCHES ".*2021.13$"
  )
)

```

Or you can try this [regular expression](https://docs.eazybi.com/eazybi/analyze-and-visualize/regular-expressions) to improve the aggregated result: “^PMWeb.\*2021.13$”

But if you want for them to be created automatically then you may find this community answer more suitable:

> [@Combining different teams sprints into one](https://community.eazybi.com/t/combining-different-teams-sprints-into-one/4120/3):
>
> With version 6.1 we added a new to create custom hierarchies in some dimensions, including Sprints. You would like to import custom properties for sprints to represent a potential grouping mechanism. For example, you can import a property cycle for Sprints with [additional data import](https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/additional-data-import-into-jira-issues-cube). Then you can use this custom property Cycle to build a [new custom hierarchy](https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestospecificJiraandConfluencedimensions) in Sprint dimension and group sprints by cycles dynamically. Import additional property to Sprint based on Sprint naming pattern XX Spr…

For that solution to work for your use case, you need to adjust the JavaScript in REST API import option to match your Sprint name pattern.

Kind regards,  
Gerda

---

_[View the full topic](https://community.eazybi.com/t/aggregate-sprint-names/3218)._