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:
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:
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.
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.
Thanks the steps seems otherwise clear but I can’t figure out how to do the authentication step. We are using Jira for Cloud and user authorization is managed through SSO from Azure AD. So which option to choose? I have tried with no authentication and username&password without luck. And when trying the oAuth, the dialog asks things I’m not sure where to get them (I’m a Jira Admin).
Hi,
We recommend using the username & password option, where your email serves as the username, and an API token is used as the password (explained in more detail here: Manage API Tokens for Your Atlassian Account).
Thank you. That worked. Now I managed to export the data but I see some odd things in the custom hierarchy. When I take all hierarchy level members, I see this:
So why do I get in the beginning some board names and the none? And the none, contains some sprint names that should have matched the pattern (sprint_name: sprint.name.match(/PI\s?\d{2}-\d/) ? LT ${sprint.name.match(/PI\s?\d{2}-\d/)[0]} : doc.name), so why are they not under the respective LT PIs?