# Combining different teams sprints into one

**URL:** <https://community.eazybi.com/t/combining-different-teams-sprints-into-one/4120>\
**Category:** Questions & Answers\
**Tags:** data-mapping, rest-api-javascript, customhierarchy\
**Created:** [April 7, 2020, 9:03pm UTC](https://community.eazybi.com/t/combining-different-teams-sprints-into-one/4120 "2020-04-07T21:03:48Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![daina.tupule](https://community.eazybi.com/user_avatar/community.eazybi.com/daina.tupule/32/8838_2.png) [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\
**Post date:** [September 15, 2020, 2:11pm UTC](https://community.eazybi.com/t/combining-different-teams-sprints-into-one/4120/3 "2020-09-15T14:11:32Z")

</div>

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 Sprint #** and you would like to retrieve the **Sprint #** only from it.

> **REST API source definition**
>
> ```auto
> {
> "application_type": "rest_api",
> "application_params": {
> "source_params": {
> "url": "https://ecosystem.atlassian.net/rest/agile/1.0/board?type=scrum",
> "pagination": "offset_limit",
> "incremental": null,
> "incremental_stop_import": null,
> "authentication_type": "basic",
> "username": "specify username",
> "content_type": "json",
> "custom_javascript_code": "// retrieves all sprints within one board and will go from the last sprint and rank decreasingly closed sprints\nvar sprints = [{\n sprint_id: null,\n sprint_name: null \n}];\nvar allSprints = [];\nvar allSprintsLoaded = false;\nstartAt = 0;\nmaxResult = 50;\nif (doc.type == \"scrum\") {\n\n do \n {\n result = getDocument( \"/rest/agile/1.0/board/\" + doc.id + \"/sprint?startAt=\" + startAt + \"&maxResults=\" + maxResult, {ignoreErrors: \"404\"});\n if (result && result.values ) {\n allSprints = allSprints.concat(result.values);\n allSprintsLoaded = result.isLast;\n startAt = startAt + maxResult;\n }\n }\n while (!allSprintsLoaded); \n \n if (allSprints ) { \n for(var i = 0; i < allSprints.length; i++) {\n var sprint = allSprints[i];\n if (sprint && sprint.originBoardId == doc.id ) {\n sprints.push({\n sprint_id: sprint.id,\n sprint_name: sprint.name.match(/( Sprint )(\\d+)/) ? sprint.name.match(/( Sprint )(\\d+)/)[0] : doc.name\n });\n }\n }\n} \n\n}\nreturn _.uniq(sprints);",
> "json_data_path": "$.values",
> "offset_parameter": "startAt",
> "limit_parameter": "maxResults",
> "limit_value": 50
> },
> "extra_options": {
> "regular_import_frequency": null,
> "regular_import_at": "",
> "time_zone": "Helsinki"
> }
> },
> "source_cube_name": "Issues",
> "columns": [
> {
> "name": "sprint_id",
> "data_type": "integer",
> "dimension": "Sprint",
> "dimension_level": "Sprint",
> "key_column": true,
> "skip_missing": true
> },
> {
> "name": "sprint_name",
> "data_type": "string",
> "dimension": "Sprint",
> "dimension_level": "Sprint",
> "property": "Cycle"
> }
> ]
> }
> 
> ```

In Source Data tab **add new source application** and in **Import definition** use the REST API source definition added above.

Update the Source data URL by a correct JIRA HOME URL/Jira site URL instead of **[https://ecosystem.atlassian.net](https://ecosystem.atlassian.net)**:

 ![image](https://community.eazybi.com/uploads/default/original/2X/0/08a6ca40a5ba57bf5ed063cf2e68fed8c8cf2d30.png)

Add the authentication to your Jira.  
If you have a different Sprint naming pattern you would like to use, update the JavaScript code by edit custom javascript code.

The current JavaScript calculation should retrieve the **Sprint #** from sprints with a naming pattern **XX Sprint #**. The mapping is in place as well to import a property for a sprint dimension with a name **Cycle**. Run an import.

After import, you can **add custom hierarchy** in Sprint dimension based on the Property **Cycle**.

 ![image](https://community.eazybi.com/uploads/default/original/2X/1/16fa90c2d0be801cbd978049819337ba4e879bda.png)

Then you can use this new Sprint cycle hierarchy in the report. You might want to reorder the members there, though. You can define a new custom report specific measure (as it is needed in a particular report only):  
Sprint number:  
`Cast(Replace( ExtractString([Sprint].CurrentHierarchyMember.Name , 'Sprint (\d+).*'), "Sprint " , "") as Numeric)`

Then you can use this measure to the report and apply the Ascending order to it.

 ![image](https://community.eazybi.com/uploads/default/original/2X/0/006157fd73f4b5fb01fa120a346fedcd44378a0a.png)

Here are several reports in **eazyBI Demo Training** account created based on this custom hierarchy.:  
[**Sprints by sprint name balance**](https://eazybi.com/accounts/22010/cubes/Issues/reports/725640-sprints-by-sprint-name-balance)  
[**Sprint by sprint name velocity**](https://eazybi.com/accounts/22010/cubes/Issues/reports/787605-sprints-by-sprint-name-velocity)  
[**Sprints by name current cycle story points burn-down**](https://eazybi.com/accounts/22010/cubes/Issues/reports/787632-sprints-by-name-current-cycle-story-points-burn-down)

Daina / [support@eazybi.com](mailto:support@eazybi.com)

---

_[View the full topic](https://community.eazybi.com/t/combining-different-teams-sprints-into-one/4120)._