Sum Story Points of child issues of Initiative

Questions & Answers
1

Hi,

I’m building a report that shows on rows the project’s sprints and, for each sprint, the total Story Points Completed. This is all ok.

But, all user stories belong to an Epic and each Epic belongs to an Initiative.

Having this in mind, I’d like to show also, for each sprint, from the Story Points completed, how many belong to issues below Initiatives with a specific label.

This is what I’m having trouble to do. I can’t/ don’t know how to filter initiatives that have that label and then filter the issues below so we can sum the story points of each of them that where resolved in that sprint.

Can you help with this?

Thanks in advance,
Nuno Lopes

2

anyone? :slight_smile: I really need help on this. Thanks

3

Hi @Nuno_Lopes

There are two steps that you need to complete to achieve this:

  1. Import this custom issue hierarchy (Initiative → Epic → … → …)
  2. Import Issue link field dimension “Initiative Label”

a) If you are using Advanced Roadmaps you can go to the import options and select “Parent link” for import:

parent-link
parent-link1568×868 61.2 KB

This will import the custom issue hierarchy.
Importing Issue link field dimension:
After this, in the Advanced settings you can define a new dimension “Initiative Label” which you will use in your reports to filter the report results by specific Initiative labels.
Add the following code to the Advanced settings:

[jira.customfield_initiative]
name = "Initiative"
inward_link = "is child of"
issue_type = "Initiative"
update_from_issue_key = "epic_key"

[[jira.issue_link_field_dimensions]]
name = "Initiative Label"
source_dimension = "Label"
issue_key_column = "customfield_initiative"
group = "Linked issue dimensions"

!!! Be sure to adjust the “inward_link” property to the one that you have in your Jira. If in your Jira the Epic “is child of” Initiative, then this can stay unchanged. If there is a different link between them, then please change this accordingly.
Save the Advanced settings, go to import options and under the “Custom fields” tab “Issue links” section select the “Initiative” for import, and in the Additional options tab select the “Initiative Label” for import and trigger the import.

Now, in your report environment, there should be an “Initiative Label” dimension under the “Linked issue dimensions” group. Use this in the Page filter to filter the report by the Initiative label.

b) If you are not using Advanced Roadmaps, you can define your own hierarchy in Advanced settings, read more here: Additional Issue hierarchies. See this Community post for detailed instructions: How to create an additional issue hierarchy
After this hierarchy is built, repeat the same steps for Importing Issue link field dimension as previously mentioned.

The result should look like this (in this example I use the Feature type):

label-filter
label-filter1306×764 69.9 KB

Let me know if you need any additional help with this, or reach out to support@eazybi.com if you face any specific challenges during the implementation of this!
Best regards,
Nauris / eazyBI support

1 Like
4

Thanks it worked!

Since I needed it as a measure, I created a new one with this:

(
[Measures].[Sprint Story Points at closing],
[Transition Status.Category].[Done],
[Initiative Label].[MYLABEL]
)

Substituting MYLABEL by the label I wanted to count.

1 Like